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 |