Frequent_Flyer_Programs

ProgramIDProgramNamePointsRequired
1MileagePlus2000
2AAdvantage3000
3SkyMiles4000
4OneWorld5000
5KrisFlyer6000

Benefits

BenefitIDBenefitType
1Free_Upgrades
2Lounge_Access
3Priority_Checkin
4Extra_Baggage
5Discounted_Flights

Frequent_Flyer_Programs_Benefits

ProgramIDBenefitID
(→ Frequent_Flyer_Programs.ProgramID)(→ Benefits.BenefitID)
11
21
31
41
51