Create a query to display all passengers information by

Question

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:

FLIGHT NUMBER	ORIGIN	DESTINATION	DEPART TIME	ARRIVE TIME
368	AUG	NAS	0923	1017
890	HPN	AUG	1410	1555
900	AUG	AUG	1535	1620

b. RESERVATION table might look like this:

FLIGHT NUMBER	FLIGHT DATE	PASSENGER NUMBER	RESERVATION CODE	SEAT NUMBER	AGENT NUMBER
368	7/6/04	ALER1098	912283	2A	412
890	6/1/04	BROT4657	289817	11A	686
890	6/1/04	BROT6182	318879	11B	686

c. PASSENGER table might look like this:

PASSENGER NUMBER	PASSENGER NAME
ALER1098	Alerion, Nathan
BROT4657	Brothers, Barbara
BROT6182	Brothers, Sam

d. RESERVATION AGENT table might look like this:

AGENT NUMBER	AGENT NAME
412	Alexis, Ramon
014	Madre, Jefferson
686	Vasquez, Wanda

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)