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