| id | name | country |
|---|---|---|
| 1 | United Airlines | USA |
| 2 | Delta Airlines | USA |
| 3 | American Airlines | USA |
| 4 | Southwest Airlines | USA |
| 5 | Air Canada | Canada |
| id | airportName | city | country |
|---|---|---|---|
| 1 | John F. Kennedy International Airport | New York | USA |
| 2 | Hartsfield-Jackson Atlanta International Airport | Atlanta | USA |
| 3 | Los Angeles International Airport | Los Angeles | USA |
| 4 | Toronto Pearson International Airport | Toronto | Canada |
| 5 | Vancouver International Airport | Vancouver | Canada |
| id | flightNumber | departureTime | arrivalTime | airlineId | originAirportId | destinationAirportId |
|---|---|---|---|---|---|---|
| (→ Airlines.id) | (→ Airports.id) | (→ Airports.id) | ||||
| 1 | UA123 | 2022-07-10 08:00:00 | 2022-07-10 10:00:00 | 1 | 1 | 2 |
| 2 | DL456 | 2022-07-10 10:00:00 | 2022-07-10 12:00:00 | 2 | 1 | 3 |
| 3 | AA789 | 2022-07-10 14:00:00 | 2022-07-10 16:00:00 | 3 | 1 | 4 |
| 4 | SW101 | 2022-07-10 16:00:00 | 2022-07-10 18:00:00 | 4 | 1 | 5 |
| 5 | AC246 | 2022-07-10 18:00:00 | 2022-07-10 20:00:00 | 5 | 1 | 6 |
| id | gateNumber | terminal | airportId |
|---|---|---|---|
| (→ Airports.id) | |||
| 1 | 1 | 1 | 1 |
| 2 | 2 | 1 | 1 |
| 3 | 3 | 1 | 1 |
| 4 | 4 | 1 | 1 |
| 5 | 5 | 1 | 1 |
| id | serviceName |
|---|---|
| 1 | Baggage_Claim |
| 2 | Food_Court |
| 3 | Duty_Free |
| 4 | Car_Rental |
| 5 | Lost_and_Found |
| gateId | serviceId |
|---|---|
| (→ Gates.id) | (→ Services.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 3 |