| FlightID | DepartureTime | ArrivalTime | AirplaneID |
|---|---|---|---|
| (→ Airplanes.AirplaneID) | |||
| 1 | 2023-04-10 10:00 | 2023-04-10 12:00 | 1 |
| 2 | 2023-04-10 14:00 | 2023-04-10 16:00 | 2 |
| 3 | 2023-04-10 18:00 | 2023-04-10 20:00 | 3 |
| 4 | 2023-04-11 10:00 | 2023-04-11 12:00 | 4 |
| 5 | 2023-04-11 14:00 | 2023-04-11 16:00 | 5 |
| PassengerId | FirstName | LastName | Age |
|---|---|---|---|
| 1 | John | Doe | 30 |
| 2 | Jane | Smith | 27 |
| 3 | Alice | Johnson | 29 |
| 4 | Bob | Williams | 35 |
| 5 | Mary | Jones | 40 |
| AirplaneID | Model | SeatCapacity |
|---|---|---|
| 1 | Boeing 737 | 180 |
| 2 | Airbus A320 | 160 |
| 3 | Embraer E190 | 100 |
| 4 | Bombardier CRJ700 | 70 |
| 5 | De Havilland Canada DHC-8 | 37 |
| FacilityID | Name | Cost |
|---|---|---|
| 1 | Terminal Building | 100000.0 |
| 2 | Parking Lot | 50000.0 |
| 3 | Security Checkpoint | 30000.0 |
| 4 | Restaurant | 20000.0 |
| 5 | Car Rental | 15000.0 |
| BaggageTypeID | Type |
|---|---|
| 1 | Cabin Baggage |
| 2 | Checked Baggage |
| FeeID | LuggageTypeID | Fees |
|---|---|---|
| (→ BaggageType.BaggageTypeID) | ||
| 1 | 1 | 25.0 |
| 2 | 1 | 28.0 |
| 3 | 2 | 25.0 |
| 4 | 2 | 30.0 |