Given the following EER model for an airline business: 

• Discuss some examples of semantics that cannot be enforced by the EER model;

• Map the model to a relational model representation. Discuss the possible loss of semantics. Clearly indicate the primary–foreign key relationships and specify NOT NULL declarations where necessary.

Transcribed Image Text:

AIRPORT Name Location Belongs to Year of prod- uction Type (1.1) PLANE (1.1) 3 Letter Abbreviation Number of seats ID (1.1) Employs PILOT (13) s served by assigned to 10.m Destination 10.A ID (0.0 EMPLOYEE STEWARD(ESS) (1) Home Address FLIGHT is assigned to Departure (LA) Date of Birth ID Name FLIGHT PLANNER vaid for CUSTOMER (Lm) ID Destination (1.1) Buys (0) TICKET Number of AirMiles Departure Price