$1.$ Create a dependency diagram for the table above.

$2.$ SECOND NORMAL FORM $(2$NF$)$:

a$.$ Show the table structure format for each table in $2$NF$.$

b$.$ Create the dependency diagrams for the resulting tables.

$3.$ THIRD NORMAL FORM $(3$NF$)$:

a$.$ Convert to $3$NF and show the table structure format for each table.

b$.$ Create the dependency diagrams for the resulting tables.

$4.$ ENTITY$-$RELATIONSHIP MODEL:

a$.$ Create the Relational Schema for all the $3$NF tables.

b$.$ Using Chen notation, create an ERD showing all the $3$NF tables. You must show the entities, relationships, connectivity, participation, and

cardinality $($do not show the attributes on the ERD$)$