PILOT PK Pilot Number Pilot Name Date of Birth Date of Hire Flew Flown by FLIGHT PK Flight Number PK Date Departure Time Arrival Time Used Used by TRIP PK Trip Number Fare Reservation Date Taken Taken by PASSENGER PK Passenger Number Passenger Name Address Telephone Number Used Used by + AIRPLANE PK Serial Number Model Passenger Capacity Year Built Manufacturer Serviced Serviced at MAINTENANCE PROCEDURE PK Procedure Number Procedure Name Frequency +4 Used Used by SERVICE PK Servicel Number Duration Located Located at MAINTENANCE LOCATION PK Location Name Address Telephone Number Manager