| 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 |
| id | airlineName |
|---|---|
| 1 | American Airlines |
| 2 | United Airlines |
| 3 | Emirates |
| 4 | British Airways |
| 5 | Air France |
| 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 |
| 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 |
| id | employeeId |
|---|---|
| (→ Employees.id) | |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| id | employeeId |
|---|---|
| (→ Employees.id) | |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |