Question #$2$

has $2$ sub$-$questions.

For each of the following tables and data:

$($i$)$ write corresponding relational schema

$($ii$)$ find all functional dependencies.

$($iii$)$ identify its current highest normal form

$($Hint: If you identify partial dependencies, the relation is in the $1$NF$).$

$($iv$)$ state the reason why the relation is in the identified normal form

$($v$)$ convert the relation into the $3$NF if necessary.

$(1)$ Primary keys are underlined.

Song

Determinants are given for this question below.

$($ii$)()$

ProducerID $$

$(2)$ Primary keys are underlined.

Enrollment