Airlines

Airline_IDName
1United Airlines
2Delta Airlines
3American Airlines
4Southwest Airlines
5Alaska Airlines

Flights

Flight_IDFlightNumberDepartureTimeArrivalTimeSourceAirportDestinationAirportAirline_ID
(→ Airports.Airport_ID)(→ Airports.Airport_ID)
1UA1232023-04-01 07:00:002023-04-01 09:00:00121
2DL4562023-04-01 10:00:002023-04-01 12:00:00232
3AA7892023-04-01 13:00:002023-04-01 15:00:00343
4SW1012023-04-01 16:00:002023-04-01 18:00:00454
5AS2462023-04-01 19:00:002023-04-01 21:00:00515

Airports

Airport_IDNameCityCountry
1Los Angeles International AirportLos AngelesUSA
2Hartsfield-Jackson Atlanta International AirportAtlantaUSA
3Dallas/Fort Worth International AirportDallasUSA
4Seattle-Tacoma International AirportSeattleUSA
5Denver International AirportDenverUSA

Terminals

Terminal_IDAirport_IDName
(→ Airports.Airport_ID)
11Terminal 1
21Terminal 2
32Maynard H. Jackson Jr. International Terminal
43Terminal A
53Terminal B

Buildings

Building_IDTerminal_IDFloor_Level
(→ Terminals.Terminal_ID)
112
213
324
432
533

Shops

Shop_IDBuilding_IDTerminal_BuildingFloor_Level
(→ Buildings.Building_ID)
11Baggage Claim1
21Concourse A Food Court2
32Concourse B Retail3
43Concourse C Lounge4
54Concourse D Newsstand1

ShopItems

Item_IDShop_IDItemNamePriceQuantity
(→ Shops.Shop_ID)
11Water Bottle2.9950
21Snack Box5.99100
32Magazine4.99200
43Chocolate Bar1.99250
54Newspaper1.49300