Rentals
rentalID | customerName | carModel | pickUpTime | dropOffTime | Rental_Car | Pick_up_Location |
1 | John Doe | Tesla Model S | 2023-01-01 08:00:00 | 2023-01-02 17:00:00 | Audi A6 | Zone D |
2 | Jane Smith | Ford Mustang | 2023-01-02 09:00:00 | 2023-01-03 18:00:00 | Chevrolet Camaro | Terminal C |
3 | Alice Johnson | Honda Accord | 2023-01-03 10:00:00 | 2023-01-04 19:00:00 | Volkswagen Jetta | Gate E |
4 | Bob Brown | Nissan Altima | 2023-01-04 11:00:00 | 2023-01-05 20:00:00 | Kia Optima | Concourse F |
5 | Charlie White | Subaru Forester | 2023-01-05 12:00:00 | 2023-01-06 21:00:00 | Mazda CX-5 | Zone D |
Shuttles
shuttleID | customerName | destination | departureTime | arrivalTime | Airport_Shuttle | Pick_up_Location |
1 | Anna Davis | New York | 2023-01-01 07:00:00 | 2023-01-01 09:00:00 | NYC Express | Zone D |
2 | Tom Green | Los Angeles | 2023-01-02 08:00:00 | 2023-01-02 10:00:00 | LA Connect | Terminal B |
3 | Emma Stone | Paris | 2023-01-03 09:00:00 | 2023-01-03 11:00:00 | Eiffel Air | Gate G |
4 | Leonardo DiCaprio | Tokyo | 2023-01-04 10:00:00 | 2023-01-04 12:00:00 | Japan Journey | Concourse H |
5 | Scarlett Johansson | London | 2023-01-05 11:00:00 | 2023-01-05 13:00:00 | British Charter | Zone D |
Passengers
passengerID | name | age | nationality |
1 | David Beckham | 39 | English |
2 | Victoria Beckham | 45 | English |
3 | Brooklyn Beckham | 23 | English |
4 | Romeo Beckham | 20 | English |
5 | Cruz Beckham | 17 | English |
Flights
flightID | airline | origin | destination | departureTime | arrivalTime |
1 | United Airlines | San Francisco | 2023-01-01 05:00:00 | 2023-01-01 07:00:00 | UA123 |
2 | Delta Airlines | Atlanta | 2023-01-02 06:00:00 | 2023-01-02 08:00:00 | DL543 |
3 | Southwest Airlines | Las Vegas | 2023-01-03 07:00:00 | 2023-01-03 09:00:00 | WN789 |
4 | American Airlines | Dallas | 2023-01-04 08:00:00 | 2023-01-04 10:00:00 | AA345 |
5 | Spirit Airlines | Orlando | 2023-01-05 09:00:00 | 2023-01-05 11:00:00 | NK126 |
Baggage
baggageID | passengerID | weight | type |
| (→ Passengers.passengerID) | | |
1 | 1 | 30 | Checked Luggage |
2 | 1 | 15 | Carry-On Bag |
3 | 2 | 20 | Checked Luggage |
4 | 2 | 10 | Carry-On Bag |
5 | 3 | 25 | Checked Luggage |