QUESTION $3$

The dependency diagram shown below indicates several dependencies.

$($a$)$ Identify and discuss each of the indicated dependencies in the diagram, explain the types of dependency that are present. Is this relation in $1NF$ explain your answer?

$(9$ marks$)$

$($b$)$ Based on the dependency diagram, create a database whose tables are at least in $2NF,$ showing the dependency diagram for each table. Explain the criteria required for a relation to be in $2$NF$.$

$(8$ marks$)$

$($c$)$ Create a database whose tables are at least in $3NF,$ showing the dependency diagram for each table.

Explain the criteria required for a relation to be in $3NF.$

$(8$ marks$)$