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 |