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)