Aviation_Maintenance_Technicians

idNameLicense_NumberYears_of_experienceSpecialization
1John DoeABC12310Mechanic
2Jane SmithXYZ7896Electrician

Flight_Attendants

idNameLicense_numberYears_of_experienceLanguages_spoken
1Mary JohnsonDEF45610English, Spanish
2Bob BrownGHI7808English, French

Aircrafts

idModelManufacturerYear_builtCurrent_status
1Boeing 777Boeing2000In Service
2Airbus A380Airbus2007Retired

Runways

idLocationLengthWidthSurface_type
1New York JFK10000.0200.0Concrete
2Los Angeles LAX12000.0250.0Asphalt

Flights

idOrigin_AirportDestination_airportDeparture_timeArrival_timeAircraft_id
(→ Aircrafts.id)
1New York JFKLos Angeles LAX2022-01-01 10:00:002022-01-01 15:00:001
2Los Angeles LAXNew York JFK2022-01-02 00:00:002022-01-02 05:00:001

Maintenance_Records

idTechnician_nameTechnician_years_experienceAircraft_modelDate_of_maintenanceDescription
1John Doe10Boeing 7772022-01-01Routine inspection
2Jane Smith6Airbus A3802022-01-02Engine overhaul