Database Design

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}

 

Last Updated on March 7, 2019 by Essay Pro