Terminals

IDName
1Terminal A
2Terminal B
3Terminal C
4Terminal D
5Terminal E

Locations

IDTerminalIDAreaName
(→ Terminals.ID)
11Departure Lounge
21Gate Area
32Arrival Hall
43Concourse A
53Concourse B

Shops

IDLocationIDShopTypeStoreName
(→ Locations.ID)
11BookstoreBarnes & Noble
21ElectronicsBest Buy
32FashionH&M
43Fast FoodMcDonalds
54PharmacyWalgreens

DutyFreeShops

IDShopIDProductDescriptionPriceQuantityInStock
(→ Shops.ID)
11Champagne199.99100
21Whiskey89.9975
32Perfume69.9950
43Cigarettes12020
54Luxury Chocolates35100

Souvenirs

IDShopIDItemNameDescriptionPriceQuantityInStock
(→ Shops.ID)
11Airport T-shirtOfficial airport souvenir t-shirt15.99200
21KeychainMetal keyring with airport logo5.99300
32Travel MugBranded travel mug12.99150
43PostcardCity postcards0.99500
54MagnetRefrigerator magnet2.99250

Employees

IDFullNamePositionPhoneNumberEmailAddress
1John DoeSecurity Officer555-1234john@airport.com
2Jane SmithFlight Attendant555-5678jane@airport.com
3Emily JohnsonCustomer Service555-9012emily@airport.com
4David BrownPilot555-3456david@airport.com
5Michael WilsonMaintenance Worker555-7890michael@airport.com