## Airlines

Airline_ID | Name
--- | ---
1 | United Airlines
2 | Delta Airlines
3 | American Airlines
4 | Southwest Airlines
5 | Alaska Airlines

## Flights

Flight_ID | FlightNumber | DepartureTime | ArrivalTime | SourceAirport | DestinationAirport | Airline_ID
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Airports.Airport_ID) | (→ Airports.Airport_ID) |
1 | UA123 | 2023-04-01 07:00:00 | 2023-04-01 09:00:00 | 1 | 2 | 1
2 | DL456 | 2023-04-01 10:00:00 | 2023-04-01 12:00:00 | 2 | 3 | 2
3 | AA789 | 2023-04-01 13:00:00 | 2023-04-01 15:00:00 | 3 | 4 | 3
4 | SW101 | 2023-04-01 16:00:00 | 2023-04-01 18:00:00 | 4 | 5 | 4
5 | AS246 | 2023-04-01 19:00:00 | 2023-04-01 21:00:00 | 5 | 1 | 5

## Airports

Airport_ID | Name | City | Country
--- | --- | --- | ---
1 | Los Angeles International Airport | Los Angeles | USA
2 | Hartsfield-Jackson Atlanta International Airport | Atlanta | USA
3 | Dallas/Fort Worth International Airport | Dallas | USA
4 | Seattle-Tacoma International Airport | Seattle | USA
5 | Denver International Airport | Denver | USA

## Terminals

Terminal_ID | Airport_ID | Name
--- | --- | ---
| (→ Airports.Airport_ID) |
1 | 1 | Terminal 1
2 | 1 | Terminal 2
3 | 2 | Maynard H. Jackson Jr. International Terminal
4 | 3 | Terminal A
5 | 3 | Terminal B

## Buildings

Building_ID | Terminal_ID | Floor_Level
--- | --- | ---
| (→ Terminals.Terminal_ID) |
1 | 1 | 2
2 | 1 | 3
3 | 2 | 4
4 | 3 | 2
5 | 3 | 3

## Shops

Shop_ID | Building_ID | Terminal_Building | Floor_Level
--- | --- | --- | ---
| (→ Buildings.Building_ID) |  |
1 | 1 | Baggage Claim | 1
2 | 1 | Concourse A Food Court | 2
3 | 2 | Concourse B Retail | 3
4 | 3 | Concourse C Lounge | 4
5 | 4 | Concourse D Newsstand | 1

## ShopItems

Item_ID | Shop_ID | ItemName | Price | Quantity
--- | --- | --- | --- | ---
| (→ Shops.Shop_ID) |  |  |
1 | 1 | Water Bottle | 2.99 | 50
2 | 1 | Snack Box | 5.99 | 100
3 | 2 | Magazine | 4.99 | 200
4 | 3 | Chocolate Bar | 1.99 | 250
5 | 4 | Newspaper | 1.49 | 300