FlightID | DepartureTime | ArrivalTime | Origin | Destination | AircraftType | SeatsAvailable |
---|---|---|---|---|---|---|
1 | 2023-07-01 10:00 | 2023-07-01 14:00 | LA | SF | Boeing 737 | 100 |
2 | 2023-07-01 11:00 | 2023-07-01 15:00 | SF | LA | Airbus A320 | 90 |
3 | 2023-07-02 08:00 | 2023-07-02 12:00 | NY | MI | Embraer E175 | 100 |
AirlineID | Name | Headquarters |
---|---|---|
1 | United Airlines | Chicago |
2 | Delta Airlines | Atlanta |
3 | Southwest Airlines | Dallas |
PilotID | FirstName | LastName | LicenseNumber | DateOfBirth |
---|---|---|---|---|
1 | John | Doe | ABCD1234 | 1980-06-01 |
2 | Jane | Smith | EFGH5678 | 1990-05-01 |
3 | Alice | Wonderland | XYZL9876 | 1985-08-01 |
FlightID | PilotID |
---|---|
(→ Flights.FlightID) | (→ Pilots.PilotID) |
1 | 1 |
2 | 2 |
3 | 3 |
HotelID | Name | Location | Price | AccomodationType |
---|---|---|---|---|
1 | Airport Hotel | Inside the airport premises | 150 | Hotel |
2 | Sleep Pod | Outside the airport near terminal | 150 | Pod |
3 | Another Airport Hotel | Inside the airport premises | 200 | Hotel |
4 | Sleep Pod | Outside the airport near terminal | 200 | Pod |
5 | Grand Plaza | Close to the city center | 250 | Resort |
6 | Economy Inn | Far from the city center | 50 | Motel |