Airlines

AirlineIDNameHeadquarters
1American AirlinesFort Worth
2Delta Air LinesAtlanta
3United AirlinesChicago
4Southwest AirlinesDallas
5JetBlue AirwaysNew York

Flights

FlightIDOriginAirportDestinationAirportDepartureTimeArrivalTimeAircraftTypeOperatedBy
(→ Airlines.AirlineID)
1DFWLAX2023-01-01 08:002023-01-01 11:00Boing 7371
2ORDMIA2023-01-02 09:002023-01-02 12:00Airbus A3202
3IAHPHX2023-01-03 10:002023-01-03 13:00Embraer E1753
4SFOSEA2023-01-04 11:002023-01-04 14:00Boeing 7574
5ATLMCO2023-01-05 12:002023-01-05 15:00Bombardier CRJ9005

Passengers

PassengerIDFirstNameLastNameDateOfBirthNationality
1JohnDoe1990-06-15USA
2JaneSmith1992-08-20UK
3EmmaNelson1988-10-05Canada
4MichaelJackson1995-12-25Australia
5DavidBrown1985-02-12Germany

Bookings

BookingIDFlightIDPassengerIDClassOfServiceBookedDate
(→ Flights.FlightID)(→ Passengers.PassengerID)
111Economy2022-12-31 10:00
222Business2023-01-01 11:00
333Premium Economy2023-01-02 12:00
444Economy2023-01-03 13:00
555Business2023-01-04 14:00

Frequent_Flyer_Lounges

LoungeIDNameLocationAmenitiesCapacity
1The ClubDFW Terminal CComplimentary Wi-Fi100
2Club ATLASATL InternationalNo Complimentary Wi-Fi150

VIP_Lounges

LoungeIDNameLocationAmenitiesAccessLevel
1First Class LoungeSFO Terminal GComplimentary Wi-FiInvitation Only
2Platinum LoungeLAX Tom Bradley IntlNo Complimentary Wi-FiBy Invitation/Membership