Given the following EER model for an airline business:

map the model to a relational model representation. Discuss the possible loss of semantics. Clearly indicate the primaryforeign key relationships and specify NOT NULL declarations where necessary

AIRPORT EMPLOYEE CUSTOMER Number Name Namo Loreto Air Miles Abbreviation Location PILOT PILOT STEWARD(ESS) FLIGHT PLANNER Belongs to Year of prod- uction Number of seats Departure Type (0) Destination Departure Destination Price PLANE FLIGHT TICKET