Flights

FlightIDDepartureTimeArrivalTimeOriginDestination
110:00:0013:00:00JFKLAX
214:00:0017:00:00ORDATL
306:00:0009:00:00YYZYUL
418:00:0021:00:00CDGDUB
509:00:0012:00:00PEKHKG

Airports

AirportIDNameCityCountry
1John F. Kennedy International AirportNew YorkUSA
2Chicago O'Hare International AirportChicagoUSA
3Toronto Pearson International AirportTorontoCanada
4Charles de Gaulle AirportParisFrance
5Hong Kong International AirportHong KongHong Kong

Airlines

AirlineIDNameHeadquartersCityHomeAirportId
(→ Airports.AirportID)
1American AirlinesFort Worth1
2United AirlinesChicago2
3Air CanadaMontrealNone
4Air FranceTremblay-en-France4
5Cathay PacificHong Kong5

Passengers

PassengerIDFirstNameLastNameDateOfBirthSpecialNeeds
1AliceSmith1990-01-151
2BobJohnson1985-02-200
3CarolWilliams1992-03-250
4DavidBrown1988-04-051
5EvaMiller1994-05-100

Assistants

AssistantIDName
1Claire Allen
2Emma Thompson
3Jack Williams
4Lucy Jones
5Michael Johnson

PassengerAssistanceRequests

RequestIDPassengerIDAssistantIDType
(→ Passengers.PassengerID)(→ Assistants.AssistantID)
111Unaccompanied Minor
222Unaccompanied Minor
331Special Needs
443Special Needs
554General Assistance