I am new to this programming world and I am learning drawing ER diagram for a small airport management suite and use the below physical data model in my project report before that, I want to verify If the the following are correct or not. (i) Relationships (ii) Primary Keys and Foreign Keys (iii) In Actual_flights_ there is a aircraft_id which must be FK but it was not mentioned as FK against it in the diagram, same with pilot_id. (iv) In table Hangers, Airport_ID is termed as FK but there is no relation between Hangers and Airports_ table.
Hence, I would like to verify before using the same ER. For your reference. I am currently developing database in access. Please help me!!
Entity Diagram