| ProgramID | ProgramName | PointsRequired |
|---|---|---|
| 1 | MileagePlus | 2000 |
| 2 | AAdvantage | 3000 |
| 3 | SkyMiles | 4000 |
| 4 | OneWorld | 5000 |
| 5 | KrisFlyer | 6000 |
| BenefitID | BenefitType |
|---|---|
| 1 | Free_Upgrades |
| 2 | Lounge_Access |
| 3 | Priority_Checkin |
| 4 | Extra_Baggage |
| 5 | Discounted_Flights |
| ProgramID | BenefitID |
|---|---|
| (→ Frequent_Flyer_Programs.ProgramID) | (→ Benefits.BenefitID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |