Reference no: EM131143544

Fastflight Database Project

Given the ERD and the data for each entity (table) do the following:

1- Define the primary keys, foreign keys, and secondary keys for each table.
2- Link all tables according the ERD
3- Design the input screens, output screens, and queries to:
a. Enter data
b. Display data
c. Modify data
d. Generate reports
a- FLIGHT table might look like this:

b. RESERVATION table might look like this:

c. PASSENGER table might look like this:

d. RESERVATION AGENT table might look like this:

Create the following:

1. Form to Add/Display/Modify/Delete FLIGHT information
2. Form to Add/Display/Modify/Delete RESER VA TION information
3. Form to Add/Display/Modify/Delete PASSENGER information
4. Form to Add/Display/Modify/Delete RESERVATION AGENT information
5. Query to display all Passengers information by using agent number as a search key.
6. Query to display passenger name by using reservation code as a search key.
7. Query to display agent name by using flight number as a search key.
8. Report to view all passengers (grouped by agent number)
9. Report to view all flights (grouped by destination)