Flights

FlightIDDepartureTimeArrivalTimeOriginDestinationTerminalNumber
118:3019:45LAXJFK101
217:0018:15ATLORD102
316:3017:45DENMIA103
415:0016:15SEAMSP104
514:3015:45PHXIAH105

Passengers

PassengerIDFirstNameLastNameDateOfBirthAvailableLocations
1JohnSmith1990-01-01Terminal A
2AnnaMartin1985-05-01Terminal C
3MichaelWilliams1992-12-24Terminal A
4EmmaJones1988-08-01Terminal C
5DavidBrown1991-03-16Terminal A

LuggageServices

LuggageServiceIDDescriptionCostLuggageAssistanceAvailableLocations
1Luggage Trolley10.0No assistance provided.Entrance B
2Luggage Trolley15.0No assistance provided.Departures D
3Porter Service20.0Meet & Greet at Entrance.Entrance B
4Porter Service25.0Meet & Greet at Exit.Exit E
5Valet Parking30.0Car picked up inside terminal.Arrivals F

Reservations

ReservationIDFlightIDPassengerIDLuggageServiceID
(→ Flights.FlightID)(→ Passengers.PassengerID)(→ LuggageServices.LuggageServiceID)
1111
2223
3335
4443
5551