Description
EXERCISE 1.
Map the following ER schema into a Relational schema. Specify all relation schemas, primary
keys, and foreign keys. [30]
EXERCISE 2.
Map the following EER schema into a Relational schema using the mapping options A and B
(from the lectures) for specialization (generalization). Specify all primary keys. Note that you
do not have to follow the same mapping option for all specializations (generalizations) in a
specialization (generalization) hierarchy. [20]
