## Airports

id | name
--- | ---
1 | John F. Kennedy International Airport
2 | Los Angeles International Airport
3 | Dubai International Airport
4 | Heathrow Airport
5 | Charles de Gaulle Airport

## Airlines

id | airlineName
--- | ---
1 | American Airlines
2 | United Airlines
3 | Emirates
4 | British Airways
5 | Air France

## Flights

id | departureTime | arrivalTime | distance | airportId | airlineId
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Airports.id) | (→ Airlines.id)
1 | 2023-01-01 08:00:00 | 2023-01-01 11:00:00 | 3500.0 | 1 | 1
2 | 2023-01-02 09:00:00 | 2023-01-02 12:00:00 | 4000.0 | 2 | 2
3 | 2023-01-03 10:00:00 | 2023-01-03 13:00:00 | 2700.0 | 3 | 3
4 | 2023-01-04 11:00:00 | 2023-01-04 14:00:00 | 4200.0 | 4 | 4
5 | 2023-01-05 12:00:00 | 2023-01-05 15:00:00 | 3800.0 | 5 | 5

## Employees

id | firstName | lastName | salary | role
--- | --- | --- | --- | ---
1 | John | Doe | $60,000 per year | Air Traffic Controller
2 | Jane | Smith | $70,000 per year | Pilot
3 | Alice | Johnson | $55,000 per year | Flight Attendant
4 | Bob | Williams | $60,000 per year | Maintenance Engineer
5 | Charlie | Brown | $65,000 per year | Cargo Handler

## Air_Traffic_Controllers

id | employeeId
--- | ---
| (→ Employees.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Ground_Staff

id | employeeId
--- | ---
| (→ Employees.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5