Airports
| id | name | location | code |
| 1 | JFK International | New York, USA | JFK |
| 2 | LAX | Los Angeles, USA | LAX |
| 3 | YYZ | Toronto, Canada | YYZ |
| 4 | LHR | London, UK | LHR |
| 5 | CDG | Paris, France | CDG |
Food_Courts
| id | airport_id | name | food_type |
| (→ Airports.id) | | |
| 1 | 1 | Taste of New York | American |
| 2 | 2 | California Delights | Fast Food |
| 3 | 3 | Maple Leaf Bistro | Canadian |
| 4 | 4 | The British Tavern | British |
| 5 | 5 | Le Petit Dejeuner | French |
Retail_Shops
| id | airport_id | name | type |
| (→ Airports.id) | | |
| 1 | 1 | Duty Free Shops | Duty Free |
| 2 | 2 | Gift Shop | Gifts |
| 3 | 3 | Books & Magazines | Bookstore |
| 4 | 4 | Electronics Store | Electronics |
| 5 | 5 | Clothing and Accessories | Clothing |
Revenue
| id | date | revenue | fc_total | rs_total |
| 1 | 2022-07-01 | $980,000 | None | None |
| 2 | 2022-07-01 | $650,000 | None | None |
| 3 | 2022-07-01 | $1,100,000 | None | None |
| 4 | 2022-07-01 | $780,000 | None | None |
| 5 | 2022-07-01 | $550,000 | None | None |
FC_RS_Revenues
| id | fc_id | rs_id | revenue_id |
| (→ Food_Courts.id) | (→ Retail_Shops.id) | (→ Revenue.id) |
| 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 2 |
| 3 | 3 | 3 | 3 |
| 4 | 4 | 4 | 4 |
| 5 | 5 | 5 | 5 |