Q$1(40-$point$)$: Give the formal or informal definitions of the following terms in relational model:

$(10-$point$)$ Super Key

$(10-$point$)$ Candidate Key

$(10-$point$)$ Primary Key

$(10-$point$)$ Foreign Key

Q$2(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.

Q$3(30-$point$)$ Give a decomposition into $3$NF of the following schema:

$r(A,B,C,D,E)$

$F=\{AB$CDE,$ACD,BDE\}$