Question $1$

$[15$ marks$]$

InterSA is a bus company that offers its travelling services to its customers throughout southern Africa. When passengers board the bus, there's usually someone who registers passengers' details using a notebook $($hardcopy$).$ The details include Name, Surname, Destination, and Contact No$.($person$-$related$).$ InterSA has approached you to help them create a graphical user interface $($GUI$)$ application that will record these details instead of recording them in a hardcopy book.

Use MySQL workbench to create a database schema named $"$fa$3\_$assessment". Within the database, create a table to store passenger details and name it "passenger$\_$details". Create the passenger$\_$details fields as follows:

TABLE: student$\_$booking

$\backslash$table$[[$Field names,Data type,$\backslash$table$[[$Primary$],[$key$]],$Description$],[$FName$,$VARCHAR$(15),$No$,$passenger's first name$],[$LName$,$VARCHAR$(15),$No$,$passenger's last name$],[$Dest$,$VARCHAR$(25),$No$,$passenger's destination$],[$Phone$,$VARCHAR$(10),$No$,$passenger's relative phone number$]]$

NB Please use the field names in the table above.

You should be able to see the following when finished:

$2$

HSYD$201-1-$Jul$-$Dec$2024-$FA$3-$OD$-$V$\mathrm{.}2-23052024$

Export your database $"$fa$3\_$assessment" and Zip$/$compress the dump folder for submission on Colcampus as your Question $1.$

Question $2$

$[35$ marks$]$

Use NetBeans IDE to create a Java Swing application $($GUI$)$ that will interact with the passenger$\_$details table where the user can enter$/$insert and view passengers who boarded the bus. Save the application as "FormativeAssessment $3$ GUI.java"

NB records$/$information MUST be entered into the table "passenger$\_$details" through the graphical user interface $($GUI$).$

You should be able to see the following when finished:

Java Swing $($GUI$)$

InterSA Boarded Passengers

$\backslash$table$[[$Name$,$Surname,,,$],[,,,,]]$

Exit

$$

After inserting the student information via the Java Swing $($GUI$)$ the records are logged in the table "student$\_$booking".

Result Grid

Filter Rows:

Exporta

$\backslash$table$[[$FName$,$LName,Dest,Phone$],[$James$,$Gada,Umtata,$0732518256],[$Sheron$,$Mthembu,EastLondon,$0862541235],[$Thembi$,$Mtyali,Gqeberha,$0835214523],[$Peter$,$Parker,GraafReneit,$0835214524],[$Hendrik$,$Botha,Gqeberha,$0835214523],[$Owen$,$Kuger,Gqeberha,$0865231425],[$Adam$,$Osthusien,EastLondon,$0865231429]]$

Wrap Cell Contents

Zip$/$compress the "FormativeAssessment $3$ GUI" project folder and submit it on ColCampus as your Questions $2.$

$\backslash$table$[[$Criteria$,$Task,Marks$],[$Question $1,\backslash$table$[[$A database is created successfully using the provided$],[$schema $($fa$3\_$assessment$)$ and table $($passenger$\_$details$)],[$names$.$ The table fields FName, LName, Dest, and Phone$],[$have been used.$]],15$ marks$],[\backslash$table$[[$MySQL$],[$Database$.]],\backslash$table$[[$The program executes without any syntax or runtime errors.$],[$The application allows users to insert and view records$],[$stored in a MySQL database using the "insert" and "view"$],[$buttons$.],[$The program uses the Java connection string to connect to$],[$the MySQL database and table.$],[$The program uses Java "insert" and "select" SQL statements$],[$Juva Program$],[$execution$]],\backslash$table$[[$to insert and view table records.$]]],[\backslash$table$[[$The application can display records from the MySQL table$],["$passenger details" and to the GUI. What is shown in the$],[$passenger$\_$details table must also be shown in the GUI.$]],10$ marks,$],[$Design of logic,$\backslash$table$[[$The program flows logically$.$ The program is user$-$friendly,$],[$as shown in the example provided.$]],5$ marks$]]$