Training_Center

IDName
1Aviation Academ
2New Horizons Aviation

Flight_Attendants

IDNameAgeExperienceHireDateTraining_Center_ID
(→ Training_Center.ID)
1John Doe2832019-06-011
2Jane Smith2722018-08-152
3Michael Johnson3052015-01-011
4Emily Davis2942017-10-102

Pilots

IDNameAgeExperienceLicenseNumberTraining_Center_ID
(→ Training_Center.ID)
1David Brown357LBAA1234C1
2Karen Miller316LAAB3456D2
3Daniel Wilson388LLBA5678E1
4Laura Taylor325LMNA9012F2

Aircrafts

IDTypeModelCapacity
1PassengerBoing 777300
2CargoMD-11100
3Private JetGulfstream V15

Flights

IDDepartureTimeArrivalTimeOriginCityDestinationCityAircraft_ID
(→ Aircrafts.ID)
12023-01-01 08:00:002023-01-01 12:00:00Los AngelesChicago1
22023-02-01 10:00:002023-02-01 14:00:00San FranciscoSeattle2
32023-03-01 12:00:002023-03-01 16:00:00MiamiAtlanta1
42023-04-01 09:00:002023-04-01 13:00:00HoustonDenver2

Assignments

IDFlight_IDPilot_IDCoPilot_ID
(→ Flights.ID)(→ Pilots.ID)(→ Pilots.ID)
1112
2234
3312
4434