Answer Happy

Answer the following questions with reference to how the ER
model in Figure 17.13 maps of the book to relational tables.
(a) How many relations will represent the ER model?
(b) How many foreign keys are mapped to the relation
representing X?
(c) Which relation(s) will have no foreign key?
(d) Using only the letter identifier for each entity, provide
appropriate names for the relations mapped from the ER model.
(e) If the cardinality for each relationship is changed to
one-to-one with total participation for all entities, how many
relations would be derived from this version of the ER model?
3. Answer the following questions with reference to how the ER model in the figure maps to relational tables. A aNo[PKY 1..1 B 1.NO (PK 1..1 1... С X No (PK 1.." NO PRY D 1.1 No PO 1.. 1..1 1.1 E eNo {PRO c a How many relations will represent the ER model? b How many foreign keys will be in the relation representing X? c Which relation(s) will have no foreign key? d Using only the letter identifier for each entity, provide appropriate names for the relations mapped from the ER model. e If the cardinality for each relationship is changed to one-to-one with total participation for all entities; how many relations would be derived from this version of the ER model?