Airplane PK SerialID Model Capacity MaintenanceDate Crew PK EmployeelD PK,FK FlightID FlightHours Reservations PK FK FlightID FK CustomerID FK PaymentID Date ReservationID Schedule PK FlightDate CrewAssignment Remaining Capacity Terrific Airlines - Flight PK FlightID FK AirplanelD FlightHours Departure Time FlightDuration Flight Date Maintenance |PK| MaintenancelD FK SerialID FK EmployeelD Description Date - Route PK RouteID Origin Destination EstDeparture EstArrival Employee PK EmployeelD Name PhoneNumber Job Title Customer PK CustomerlD Name PhoneNumber - Payment PK PaymentID FK CustomerID 3. Create a data dictionary that lists at least each of the tables, the columns, their domains and any other constraints that apply. (15 marks)