Given the following EER model for an electricity market:

• 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:

Location ID Name ELECTRICITY (1m) PRODUCER (0) Owne (tm) GAS POWER PLANT (0) MW/H Number of pipelines Sells Regulates Location WIND 10.n) (1.1) Number of mills Manager ELECTRICITY RESELLER Brand Name LOCAL REGULATOR Province Number of Employees Manager NUCLEAR Has contract with Number of reactors 10.0 RESIDENTIAL Household size ID Contract Type CUSTOMER BUSINESS VAT Number