## Terminals

ID | Name
--- | ---
1 | Terminal A
2 | Terminal B
3 | Terminal C
4 | Terminal D
5 | Terminal E

## Locations

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

## Shops

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

## DutyFreeShops

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

## Souvenirs

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

## Employees

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