## Flights

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

## Airlines

AirlineID | Name | Headquarters
--- | --- | ---
1 | United Airlines | Chicago
2 | Delta Airlines | Atlanta
3 | Southwest Airlines | Dallas

## Pilots

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

## AssignPilotToFlight

FlightID | PilotID
--- | ---
(→ Flights.FlightID) | (→ Pilots.PilotID)
1 | 1
2 | 2
3 | 3

## Hotels

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