| 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 |
| ID | Name | Code |
|---|---|---|
| 1 | United Airlines | UA |
| 2 | Delta Airlines | DL |
| 3 | Southwest Airlines | WN |
| 4 | JetBlue Airways | B6 |
| 5 | Spirit Airlines | NK |
| 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 |
| BenefitId | Description |
|---|---|
| 1 | Elite Status |
| 2 | Priority Boarding |
| 3 | Free Baggage Check |
| 4 | Lounge Access |
| 5 | Preferred Seating |
| ProgramId | BenefitId |
|---|---|
| (→ Frequent_Flyer_Program.ProgramId) | (→ Benefits.BenefitId) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 2 |
| 3 | 4 |