| id | Arrival_Facilities | Maximum_Capacity | OpeningHours |
|---|---|---|---|
| 1 | Arrival Hall | 500 passengers | 06:00 - 23:00 |
| 2 | Arrival Hall | 1000 passengers | 07:00 - 22:00 |
| 3 | Baggage Reclaim | 500 passengers | 08:00 - 21:00 |
| 4 | Baggage Reclaim | 800 passengers | 09:00 - 20:00 |
| id | Name | Location | NumberOfTerminals |
|---|---|---|---|
| (→ TerminalFacility.id) | |||
| 1 | Los Angeles International Airport | California, USA | 9 |
| 2 | Dubai International Airport | United Arab Emirates | 3 |
| id | Name | Headquarters | IATA_Code |
|---|---|---|---|
| 1 | Emirates | Dubai, United Arab Emirates | EK |
| 2 | American Airlines | Fort Worth, Texas, U.S. | AA |
| id | FlightNo | DepartureAirportId | DestinationAirportId | AirlineId | Departs | Arrives |
|---|---|---|---|---|---|---|
| (→ Airports.id) | (→ Airports.id) | (→ Airlines.id) | ||||
| 1 | 1 | 1 | 2 | 1 | 2023-04-01 10:00:00 | 2023-04-01 14:00:00 |
| 2 | 2 | 1 | 3 | 2 | 2023-04-01 11:00:00 | 2023-04-01 15:00:00 |
| id | FirstName | LastName | DateOfBirth | FlightId |
|---|---|---|---|---|
| (→ Flights.id) | ||||
| 1 | John | Smith | 1990-01-01 | 1 |
| 2 | Jane | Doe | 1992-02-02 | 2 |