Given the dependency diagram shown below answer questions part $a,b$ and $c$

Primary keys are underlined.

$($a$)$ Identify and discuss each of the indicated dependencies. $($b$)$ Create a database whose tables are at least in $2$NF$,$ showing the dependency diagrams for

each

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

each table