a$)$

i$.$ Identify and discuss each of the indicated dependencies.

ii$.$ Create a database whose tables are at least in $2NF,$ showing the dependency diagrams for each table.

iii. Create a database whose tables are at least in $3NF,$ showing the dependency diagrams for each table.

$(3)$