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 |