## TerminalFacility

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

## Airports

id | Name | Location | NumberOfTerminals
--- | --- | --- | ---
|  |  | (→ TerminalFacility.id)
1 | Los Angeles International Airport | California, USA | 9
2 | Dubai International Airport | United Arab Emirates | 3

## Airlines

id | Name | Headquarters | IATA_Code
--- | --- | --- | ---
1 | Emirates | Dubai, United Arab Emirates | EK
2 | American Airlines | Fort Worth, Texas, U.S. | AA

## Flights

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

## Passengers

id | FirstName | LastName | DateOfBirth | FlightId
--- | --- | --- | --- | ---
|  |  |  | (→ Flights.id)
1 | John | Smith | 1990-01-01 | 1
2 | Jane | Doe | 1992-02-02 | 2