Airlines

IDNameCountry
1DeltaUSA
2British AirwaysUK
3EmiratesUAE
4QantasAustralia
5KLM Royal Dutch AirlinesNetherlands

Airports

IDNameCityCountryAirport_Code
1Hartsfield-Jackson Atlanta International AirportAtlantaUSAATL
2Heathrow AirportLondonUKLHR
3Dubai International AirportDubaiUAEDXB
4Sydney Kingsford Smith AirportSydneyAustraliaSYD
5Schiphol AirportAmsterdamNetherlandsAMS

Flights

FlightIDOriginIDDestinationIDDepartureTimeArrivalTimeSeatCapacity
(→ Airports.ID)(→ Airports.ID)
1122023-06-01 08:00:002023-06-01 11:00:00250
2342023-07-01 10:00:002023-07-01 13:00:00300
3132023-08-01 09:00:002023-08-01 12:00:00220
4422023-09-01 07:00:002023-09-01 10:00:00180
5212023-10-01 14:00:002023-10-01 17:00:00190

Airports_Services

ServiceTypeDescriptionDateAirportID
(→ Airports.ID)
Lost PropertyAssistance with lost items at the airport.2023-06-011
Customer ComplaintsAddressing customer complaints and concerns.2023-06-012
Information DeskProviding information about airport facilities and services.2023-07-013
Security CheckpointEnsuring safety and security during travel.2023-08-014
Lost PropertyAssistance with lost items at the airport.2023-09-015