Airline_ID | Name |
---|---|
1 | United Airlines |
2 | Delta Airlines |
3 | American Airlines |
4 | Southwest Airlines |
5 | Alaska Airlines |
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 |
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 |
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 |
Building_ID | Terminal_ID | Floor_Level |
---|---|---|
(→ Terminals.Terminal_ID) | ||
1 | 1 | 2 |
2 | 1 | 3 |
3 | 2 | 4 |
4 | 3 | 2 |
5 | 3 | 3 |
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 |
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 |