Airlines

idname
1Airline A
2Airline B

Airports

idnamecitycountrycode
1Airport XCity ZCountry YXYZ
2Airport WCity VCountry UWVU

Flights

iddeparture_airport_idarrival_airport_idairline_idscheduled_departureactual_departurescheduled_arrivalactual_arrivalflight_number
(→ Airports.id)(→ Airports.id)(→ Airlines.id)
11212023-01-01 10:00:002023-01-01 10:30:002023-01-01 11:00:002023-01-01 11:30:00AA123
22122023-01-02 10:00:002023-01-02 10:30:002023-01-02 11:00:002023-01-02 11:30:00BB456

Flight_Disruptions

idflight_iddisruption_typedescription
(→ Flights.id)
11Weather ConditionHeavy rain caused a delay
22Weather ConditionFoggy weather led to cancellation
31Mechanical IssueEngine issue caused a delay
42Mechanical IssueBrake failure resulted in cancellation

Flight_Statuses

idflight_idstatus
(→ Flights.id)
11Delayed
22Cancelled