Airports

IDNameCityCountry
1Chicago O'Hare International AirportChicagoUSA
2Dallas/Fort Worth International AirportDFWUSA
3Los Angeles International AirportLAXUSA
4New York John F. Kennedy International AirportNYCUSA
5London Heathrow AirportLondonUK

Airlines

IDNameCode
1United AirlinesUA
2Delta AirlinesDL
3Southwest AirlinesWN
4JetBlue AirwaysB6
5Spirit AirlinesNK

Frequent_Flyer_Program

ProgramIdAirlineIdMemberNameJoinDate
(→ Airlines.ID)
11John Doe2022-01-01
22Jane Smith2022-07-01
33Mike Johnson2022-10-01
44Emily Brown2022-11-01
55David Wilson2022-12-01

Benefits

BenefitIdDescription
1Elite Status
2Priority Boarding
3Free Baggage Check
4Lounge Access
5Preferred Seating

Frequent_Flyer_Program_Benefits

ProgramIdBenefitId
(→ Frequent_Flyer_Program.ProgramId)(→ Benefits.BenefitId)
11
21
31
41
51
52
34