Flight

FlightIDDepartureTimeDestinationDuration
12023-04-01 08:00:00New York6
22023-04-01 09:00:00Chicago7
32023-04-01 10:00:00Los Angeles8
42023-04-01 11:00:00Miami7
52023-04-01 12:00:00Houston6

Weather

WeatherIDDescriptionTemperature
1Clear Skies75.0
2Rainy65.0
3Foggy70.0
4Stormy80.0
5Sunny85.0

Mechanical

IssueIDTypeOfIssueSeverity
1Engine TroubleHigh
2Landing Gear ProblemMedium
3Electrical System FailureLow
4Brakes IssuesMedium
5Fire Extinguisher MissingHigh

Aircraft

AircraftIDModelCapacityCurrentAirport
1Boeing 747300JFK
2Airbus A380400LAX
3Bombardier CRJ70050ORD
4Embraer E19070MIA
5Beechcraft King Air C908HOU

Pilot

PilotIDNameLicenseNumberExperienceYears
1John SmithABCD123410
2Jane DoeEFGH56788
3Tom JohnsonIJKL90125
4Emily WilliamsLMNOP34567
5David BrownQRST789012

MaintenanceRecord

RecordIDAircraftIDLastMaintenanceDate
(→ Aircraft.AircraftID)
112022-04-01 00:00:00
222021-04-01 00:00:00
332022-03-01 00:00:00
442021-04-01 00:00:00
552022-04-01 00:00:00

Flight_status

StatusIDFlightIDWeatherIDIssueIDAircraftIDPilotIDRecordIDStatusDescription
(→ Flight.FlightID)(→ Weather.WeatherID)(→ Mechanical.IssueID)(→ Aircraft.AircraftID)(→ Pilot.PilotID)(→ MaintenanceRecord.RecordID)
1111111Cancelled - Bad Weather & Engine Trouble
2122122Delayed - Rainy & Landing Gear Problem
3233233On Time - Foggy & Electrical System Failure
4344344Cancelled - Stormy & Brakes Issues
5455455Postponed - Sunny & Fire Extinguisher Missing