Airports

idnamelocation
1John F. Kennedy International AirportNew York
2Los Angeles International AirportCalifornia

Runways

idairportIdlengthwidth
(→ Airports.id)
119872.3150.0
219945.6160.0

Terminals

idairportIdterminalNumbercapacity
(→ Airports.id)
11120
21230

Airlines

idairlineNameheadquarters
1American AirlinesFort Worth, Texas
2United AirlinesChicago, Illinois

Flights

iddepartureTerminalarrivalTerminaldepartureTimearrivalTimeairplaneTypeairlineId
(→ Terminals.id)(→ Terminals.id)(→ Airlines.id)
1122023-04-01 10:00:002023-04-01 12:00:00Boeing 7371
2122023-04-01 14:00:002023-04-01 16:00:00Airbus A3202

Personnel

idrolesalaryworkHours
(→ Roles.name)
1Air Traffic Controller60000.040
2Air Traffic Controller65000.040
3Ground Staff60000.040
4Ground Staff65000.040

Roles

idname
1Air Traffic Controller
2Ground Staff