Flight_Attendants

idNameAgeExperience_YearsTraining_Center
(→ Aviation_Academies.Name)
1John Doe308.5Aviation Academy
2Jane Smith276.5Global Aero Institute

Pilots

idNameAgeLicensesTraining_Center
(→ Aviation_Academies.Name)
1Michael Johnson32{ATPL, CPL}Aviation Academy
2Emily Brown31{ATPL, CPL}World Flight School

Aviation_Academies

idNameLocationYears_Operating
1Aviation AcademyNew York25
2Global Aero InstituteLos Angeles10

Airlines

idNameHeadquartersFleet_Size
1American AirlinesFort Worth, TX953
2Delta AirlinesAtlanta, GA755

Aircrafts

idModelManufacturerYear_Manufactured
1Boeing 737Boeing1967
2Airbus A320Airbus1988

Flight_Routes

idRoute_NumberOrigin_AirportDestination_AirportDistance
1AA123DFWLAX2000.0
2DL456ATLMIA1500.0