Database

Q1 (40-point): Give the formal or informal definitions of the following terms in relational model: 1) (10-point) Super Key 2) (10-point) Candidate Key 3) (10-point) Primary Key 4) (10-point) Foreign Key Q2 (30-point) Consider the following ER-Diagram: Construct a relational database schema corresponding to the ER-diagram and specify the primary keys and foreign keys. For each foreign key, specify the referenced table and its corresponding key. 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 (30-point) Give a decomposition into 3NF of the following schema: r(A,B,C,D,E)F={ABCDE,ACD,BDE}