For this assignment, you are requested to develop front-end and back-end pages for an application to store the information of flights in a SQL database. To start with, let’s define a flight. A flight is identified with the following information:

Flight Number: Integer

Flight Duration: Byte

Source: String

Destination: String

Departure Time: Date/Time


You are requested to develop two UIs and corresponding back-end to support these front-end pages. The main UI for this application is used to enter the data for flights. So, you will need to design a UI so that the user can input all required information for flight.

Note: You are requested to do input-validation for your forms (client-side input validation)


Next, you will need to design another UI so that the user can retrieve the following information:

a. All flights whose destination is a specific city (The list of flights must be displayed on a table)

b. All flights who fly on a specific date (not time)

c. Number of flights in a specific day

To perform this, in your webpage, create three text-boxes, one for each query. In front of each text-box, add a button with title “Run Query”. Once clicked, the button sends the data provided in the text-box to the server to be processed. The server, then send the responds to the client after processing it.

To submit:

1 – Create a word (docx) file and place the name of the team-members in it. Also, you are required to explain the share of each student in the project.

Note: A student whose name is missing will receive a zero grade.

2 – Place your back-end and front-end files in one folder, zip it and submit through moodle.