Airports

idname
1John F. Kennedy International Airport
2Los Angeles International Airport
3Dubai International Airport
4Heathrow Airport
5Charles de Gaulle Airport

Airlines

idairlineName
1American Airlines
2United Airlines
3Emirates
4British Airways
5Air France

Flights

iddepartureTimearrivalTimedistanceairportIdairlineId
(→ Airports.id)(→ Airlines.id)
12023-01-01 08:00:002023-01-01 11:00:003500.011
22023-01-02 09:00:002023-01-02 12:00:004000.022
32023-01-03 10:00:002023-01-03 13:00:002700.033
42023-01-04 11:00:002023-01-04 14:00:004200.044
52023-01-05 12:00:002023-01-05 15:00:003800.055

Employees

idfirstNamelastNamesalaryrole
1JohnDoe$60,000 per yearAir Traffic Controller
2JaneSmith$70,000 per yearPilot
3AliceJohnson$55,000 per yearFlight Attendant
4BobWilliams$60,000 per yearMaintenance Engineer
5CharlieBrown$65,000 per yearCargo Handler

Air_Traffic_Controllers

idemployeeId
(→ Employees.id)
11
22
33
44
55

Ground_Staff

idemployeeId
(→ Employees.id)
11
22
33
44
55