| 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 | Another 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 |