Airplane PK SerialID Model Capacity MaintenanceDate Crew PK EmployeelD PK,FK FlightID FlightHours Reservations PK FK FlightID...

Transcribed Image Text:

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) 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)