ID | ProjectName | Increased_Capacity | StartDate | EndDate | Cost |
---|---|---|---|---|---|
1 | Airport Expansion | 1000 Passengers per Day | 2023-01-01 | 2023-12-31 | 1000000.0 |
2 | Airport Expansion | 500 Passengers per Day | 2024-01-01 | 2024-12-31 | 800000.0 |
3 | Renovation | 1000 Passengers per Day | 2023-07-01 | 2023-12-31 | 600000.0 |
4 | Renovation | 500 Passengers per Day | 2024-01-01 | 2024-12-31 | 500000.0 |
5 | Terminal Upgrade | 200 Passengers per Day | 2023-09-01 | 2023-12-31 | 400000.0 |
ID | Model | Capacity | Manufacturer | Year |
---|---|---|---|---|
1 | Boeing 737 MAX | 230 | Boeing | 2022 |
2 | Airbus A320neo | 180 | Airbus | 2021 |
3 | Embraer E195-E2 | 120 | Embraer | 2019 |
4 | Bombardier CRJ900 | 90 | Bombardier | 2018 |
5 | De Havilland Canada DHC-8 Q400 | 78 | De Havilland Canada | 2017 |
ID | DepartureTime | ArrivalTime | Origin | Destination | AircraftID |
---|---|---|---|---|---|
(→ Aircraft.ID) | |||||
1 | 07:00 AM | 08:30 AM | New York | Los Angeles | 1 |
2 | 09:00 AM | 10:30 AM | Chicago | Miami | 2 |
3 | 11:00 AM | 12:30 PM | San Francisco | Honolulu | 3 |
4 | 01:00 PM | 03:30 PM | Dallas | Atlanta | 4 |
5 | 03:00 PM | 05:30 PM | Philadelphia | Orlando | 5 |
ID | Name | Position | Salary | HireDate |
---|---|---|---|---|
1 | John Doe | Pilot | 75000.0 | 2021-01-01 |
2 | Jane Smith | Flight Attendant | 50000.0 | 2020-07-01 |
3 | Tom Johnson | Mechanic | 55000.0 | 2019-01-01 |
4 | Emily Brown | Air Traffic Controller | 60000.0 | 2018-01-01 |
5 | William Davis | Security Officer | 40000.0 | 2017-01-01 |