## Airlines

ID | Name | Country
--- | --- | ---
1 | Delta | USA
2 | British Airways | UK
3 | Emirates | UAE
4 | Qantas | Australia
5 | KLM Royal Dutch Airlines | Netherlands

## Airports

ID | Name | City | Country | Airport_Code
--- | --- | --- | --- | ---
1 | Hartsfield-Jackson Atlanta International Airport | Atlanta | USA | ATL
2 | Heathrow Airport | London | UK | LHR
3 | Dubai International Airport | Dubai | UAE | DXB
4 | Sydney Kingsford Smith Airport | Sydney | Australia | SYD
5 | Schiphol Airport | Amsterdam | Netherlands | AMS

## Flights

FlightID | OriginID | DestinationID | DepartureTime | ArrivalTime | SeatCapacity
--- | --- | --- | --- | --- | ---
| (→ Airports.ID) | (→ Airports.ID) |  |  |
1 | 1 | 2 | 2023-06-01 08:00:00 | 2023-06-01 11:00:00 | 250
2 | 3 | 4 | 2023-07-01 10:00:00 | 2023-07-01 13:00:00 | 300
3 | 1 | 3 | 2023-08-01 09:00:00 | 2023-08-01 12:00:00 | 220
4 | 4 | 2 | 2023-09-01 07:00:00 | 2023-09-01 10:00:00 | 180
5 | 2 | 1 | 2023-10-01 14:00:00 | 2023-10-01 17:00:00 | 190

## Airports_Services

ServiceType | Description | Date | AirportID
--- | --- | --- | ---
|  |  | (→ Airports.ID)
Lost Property | Assistance with lost items at the airport. | 2023-06-01 | 1
Customer Complaints | Addressing customer complaints and concerns. | 2023-06-01 | 2
Information Desk | Providing information about airport facilities and services. | 2023-07-01 | 3
Security Checkpoint | Ensuring safety and security during travel. | 2023-08-01 | 4
Lost Property | Assistance with lost items at the airport. | 2023-09-01 | 5