Air_traffic_controller

idNameExperienceSalaryTraining_Center
1John Doe860000 per yearATC Academy
2Jane Smith1270000 per yearAviation Institute

Ground_staff

idNameExperienceSalaryRole
1Mike Johnson560000 per yearBaggage Handler
2Emma Brown355000 per yearGate Agent

Flight

idDateTimeDestinationPilot_id
(→ Pilots.id)
12022-01-0110:00:00New York1
22022-01-0215:00:00Los Angeles2

Pilots

idNameLicense_NumberTotal_Flights
1Tom WilliamsABCD1234300
2Linda DavisEFGH5678500

Runway

idLengthWidthLocation
19000.0150.0Chicago O'Hare International Airport
28000.0140.0Dallas/Fort Worth International Airport

Planes

idModelRegistration_numberCapacityCurrent_Location
(→ Runway.id)
1Boeing 737N123452001
2Airbus A320N678902202