Development_Projects

IDProjectNameIncreased_CapacityStartDateEndDateCost
1Airport Expansion1000 Passengers per Day2023-01-012023-12-311000000.0
2Airport Expansion500 Passengers per Day2024-01-012024-12-31800000.0
3Renovation1000 Passengers per Day2023-07-012023-12-31600000.0
4Renovation500 Passengers per Day2024-01-012024-12-31500000.0
5Terminal Upgrade200 Passengers per Day2023-09-012023-12-31400000.0

Aircraft

IDModelCapacityManufacturerYear
1Boeing 737 MAX230Boeing2022
2Airbus A320neo180Airbus2021
3Embraer E195-E2120Embraer2019
4Bombardier CRJ90090Bombardier2018
5De Havilland Canada DHC-8 Q40078De Havilland Canada2017

Flight

IDDepartureTimeArrivalTimeOriginDestinationAircraftID
(→ Aircraft.ID)
107:00 AM08:30 AMNew YorkLos Angeles1
209:00 AM10:30 AMChicagoMiami2
311:00 AM12:30 PMSan FranciscoHonolulu3
401:00 PM03:30 PMDallasAtlanta4
503:00 PM05:30 PMPhiladelphiaOrlando5

Staff

IDNamePositionSalaryHireDate
1John DoePilot75000.02021-01-01
2Jane SmithFlight Attendant50000.02020-07-01
3Tom JohnsonMechanic55000.02019-01-01
4Emily BrownAir Traffic Controller60000.02018-01-01
5William DavisSecurity Officer40000.02017-01-01