## Airports

ID | Name | City | Country
--- | --- | --- | ---
1 | Chicago O'Hare International Airport | Chicago | USA
2 | Dallas/Fort Worth International Airport | DFW | USA
3 | Los Angeles International Airport | LAX | USA
4 | New York John F. Kennedy International Airport | NYC | USA
5 | London Heathrow Airport | London | UK

## Airlines

ID | Name | Code
--- | --- | ---
1 | United Airlines | UA
2 | Delta Airlines | DL
3 | Southwest Airlines | WN
4 | JetBlue Airways | B6
5 | Spirit Airlines | NK

## Frequent_Flyer_Program

ProgramId | AirlineId | MemberName | JoinDate
--- | --- | --- | ---
| (→ Airlines.ID) |  |
1 | 1 | John Doe | 2022-01-01
2 | 2 | Jane Smith | 2022-07-01
3 | 3 | Mike Johnson | 2022-10-01
4 | 4 | Emily Brown | 2022-11-01
5 | 5 | David Wilson | 2022-12-01

## Benefits

BenefitId | Description
--- | ---
1 | Elite Status
2 | Priority Boarding
3 | Free Baggage Check
4 | Lounge Access
5 | Preferred Seating

## Frequent_Flyer_Program_Benefits

ProgramId | BenefitId
--- | ---
(→ Frequent_Flyer_Program.ProgramId) | (→ Benefits.BenefitId)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 2
3 | 4