| ID | Name |
|---|---|
| 1 | Terminal A |
| 2 | Terminal B |
| 3 | Terminal C |
| 4 | Terminal D |
| 5 | Terminal E |
| ID | TerminalID | AreaName |
|---|---|---|
| (→ Terminals.ID) | ||
| 1 | 1 | Departure Lounge |
| 2 | 1 | Gate Area |
| 3 | 2 | Arrival Hall |
| 4 | 3 | Concourse A |
| 5 | 3 | Concourse B |
| ID | LocationID | ShopType | StoreName |
|---|---|---|---|
| (→ Locations.ID) | |||
| 1 | 1 | Bookstore | Barnes & Noble |
| 2 | 1 | Electronics | Best Buy |
| 3 | 2 | Fashion | H&M |
| 4 | 3 | Fast Food | McDonalds |
| 5 | 4 | Pharmacy | Walgreens |
| ID | ShopID | ProductDescription | Price | QuantityInStock |
|---|---|---|---|---|
| (→ Shops.ID) | ||||
| 1 | 1 | Champagne | 199.99 | 100 |
| 2 | 1 | Whiskey | 89.99 | 75 |
| 3 | 2 | Perfume | 69.99 | 50 |
| 4 | 3 | Cigarettes | 120 | 20 |
| 5 | 4 | Luxury Chocolates | 35 | 100 |
| ID | ShopID | ItemName | Description | Price | QuantityInStock |
|---|---|---|---|---|---|
| (→ Shops.ID) | |||||
| 1 | 1 | Airport T-shirt | Official airport souvenir t-shirt | 15.99 | 200 |
| 2 | 1 | Keychain | Metal keyring with airport logo | 5.99 | 300 |
| 3 | 2 | Travel Mug | Branded travel mug | 12.99 | 150 |
| 4 | 3 | Postcard | City postcards | 0.99 | 500 |
| 5 | 4 | Magnet | Refrigerator magnet | 2.99 | 250 |
| ID | FullName | Position | PhoneNumber | EmailAddress |
|---|---|---|---|---|
| 1 | John Doe | Security Officer | 555-1234 | john@airport.com |
| 2 | Jane Smith | Flight Attendant | 555-5678 | jane@airport.com |
| 3 | Emily Johnson | Customer Service | 555-9012 | emily@airport.com |
| 4 | David Brown | Pilot | 555-3456 | david@airport.com |
| 5 | Michael Wilson | Maintenance Worker | 555-7890 | michael@airport.com |