ID | Name | Country |
---|---|---|
1 | Delta | USA |
2 | British Airways | UK |
3 | Emirates | UAE |
4 | Qantas | Australia |
5 | KLM Royal Dutch Airlines | Netherlands |
ID | Name | City | Country | Airport_Code |
---|---|---|---|---|
1 | Hartsfield-Jackson Atlanta International Airport | Atlanta | USA | ATL |
2 | Heathrow Airport | London | UK | LHR |
3 | Dubai International Airport | Dubai | UAE | DXB |
4 | Sydney Kingsford Smith Airport | Sydney | Australia | SYD |
5 | Schiphol Airport | Amsterdam | Netherlands | AMS |
FlightID | OriginID | DestinationID | DepartureTime | ArrivalTime | SeatCapacity |
---|---|---|---|---|---|
(→ Airports.ID) | (→ Airports.ID) | ||||
1 | 1 | 2 | 2023-06-01 08:00:00 | 2023-06-01 11:00:00 | 250 |
2 | 3 | 4 | 2023-07-01 10:00:00 | 2023-07-01 13:00:00 | 300 |
3 | 1 | 3 | 2023-08-01 09:00:00 | 2023-08-01 12:00:00 | 220 |
4 | 4 | 2 | 2023-09-01 07:00:00 | 2023-09-01 10:00:00 | 180 |
5 | 2 | 1 | 2023-10-01 14:00:00 | 2023-10-01 17:00:00 | 190 |
ServiceType | Description | Date | AirportID |
---|---|---|---|
(→ Airports.ID) | |||
Lost Property | Assistance with lost items at the airport. | 2023-06-01 | 1 |
Customer Complaints | Addressing customer complaints and concerns. | 2023-06-01 | 2 |
Information Desk | Providing information about airport facilities and services. | 2023-07-01 | 3 |
Security Checkpoint | Ensuring safety and security during travel. | 2023-08-01 | 4 |
Lost Property | Assistance with lost items at the airport. | 2023-09-01 | 5 |