Employees

idNameYears_of_experience
1John Doe10
2Jane Smith7
3Alice Johnson12
4Bob Brown8
5Charlie Davis9

Aviation_Maintenance_Technicians

idEmployeeIDCertification_Level
(→ Employees.id)
11Level I
22Level II
33Level III
44Level IV
55Level V

Flight_Attendants

idEmployeeIDLanguage_proficiency
(→ Employees.id)
11English, Spanish
22English, French
33English, German
44English, Italian
55English, Russian

Planes

idModelCapacity
1Boeing 747400
2Airbus A380860
3Bombardier CRJ-90084
4Embraer E19096
5Airbus A220124

Flights

idSourceDestinationDeparture_TimeArrival_TimeAircraftID
(→ Planes.id)
1New YorkLondon2023-01-01 08:002023-01-01 11:001
2Los AngelesTokyo2023-01-02 08:002023-01-02 11:002
3ParisDubai2023-01-03 08:002023-01-03 11:003
4Rio de JaneiroSão Paulo2023-01-04 08:002023-01-04 11:004
5Cape TownJohannesburg2023-01-05 08:002023-01-05 11:005

Maintenance_Records

idTechnicianIDPlaneIDDate_performedWork_completed
(→ Aviation_Maintenance_Technicians.id)(→ Planes.id)
1112023-01-01Engine inspection and replacement of filters
2222023-01-02Landing gear overhaul
3332023-01-03Wing inspection and repair of minor damage
4442023-01-04Avionics system upgrade
5552023-01-05Fuel system cleaning and leak check