Q1. Consider the following ER-Diagram: Construct a relational database schema corresponding to the ER-diagram and specify primary keys and foreign keys. For each foreign key, specify the referenced table. You can rename the attributes. The attribute names of a foreign key and those of the targeted primary key need not be the same.
Q2. Consider the following ER-Diagram: Construct a relational database schema corresponding to the ER-diagram and specify primary keys and foreign keys. For each foreign key, specify the referenced table. You can rename the attributes. The attribute names of a foreign key and those of the targeted primary key need not be the same.
Q3. Give a decomposition into 3NF of the following schema:
r(A,B,C,D,E)
F={ABàCDE, ACàD, BDàE}