| ID | LocationName |
|---|---|
| 1 | Zone A |
| 2 | Zone B |
| 3 | Zone C |
| 4 | Zone D |
| 5 | Zone E |
| AirlineID | Name | Code |
|---|---|---|
| 1 | American | AA |
| 2 | United | UA |
| 3 | Delta | DL |
| 4 | Southwest | WN |
| 5 | Alaska | AS |
| FlightNumber | DepartureTime | Destination | Origin | AirlineID |
|---|---|---|---|---|
| (→ Airlines.AirlineID) | ||||
| 101 | 2023-04-01 10:00:00 | New York | Los Angeles | 1 |
| 102 | 2023-04-01 11:00:00 | San Francisco | Chicago | 2 |
| 103 | 2023-04-01 12:00:00 | Dallas | Atlanta | 3 |
| 104 | 2023-04-01 13:00:00 | Seattle | Honolulu | 4 |
| 105 | 2023-04-01 14:00:00 | Miami | Boston | 5 |
| PassengerID | FirstName | LastName | PhoneNumber | PickedUpFrom | |
|---|---|---|---|---|---|
| (→ Pick_Up_Locations.ID) | |||||
| 1 | John | Doe | +1234567890 | john.doe@example.com | None |
| 2 | Jane | Smith | +0987654321 | jane.smith@example.com | None |
| 3 | Michael | Johnson | +1112223333 | michael.johnson@example.com | None |
| 4 | Emily | Williams | +2223334444 | emily.williams@example.com | None |
| 5 | David | Brown | +3334445555 | david.brown@example.com | None |
| RentalID | PickUpDate | DropOffDate | CarModel | CustomerID | PickUpLocationID |
|---|---|---|---|---|---|
| (→ Passengers.PassengerID) | (→ Pick_Up_Locations.ID) | ||||
| 1 | 2023-04-01 09:00:00 | 2023-04-01 18:00:00 | Toyota Camry | 1 | 1 |
| 2 | 2023-04-02 09:00:00 | 2023-04-02 18:00:00 | Ford Explorer | 2 | 2 |
| 3 | 2023-04-03 09:00:00 | 2023-04-03 18:00:00 | Chevrolet Malibu | 3 | 3 |
| 4 | 2023-04-04 09:00:00 | 2023-04-04 18:00:00 | Nissan Altima | 4 | 4 |
| 5 | 2023-04-05 09:00:00 | 2023-04-05 18:00:00 | Honda Accord | 5 | 5 |
| ShuttleID | Schedule | Terminal | Capacity | PickUpLocationID |
|---|---|---|---|---|
| (→ Pick_Up_Locations.ID) | ||||
| 1 | 2023-04-01 07:00:00 | 1 | 10 | 1 |
| 2 | 2023-04-02 07:00:00 | 2 | 12 | 2 |
| 3 | 2023-04-03 07:00:00 | 3 | 8 | 3 |
| 4 | 2023-04-04 07:00:00 | 4 | 10 | 4 |
| 5 | 2023-04-05 07:00:00 | 5 | 12 | 5 |