One supervisor can be assigned to only one department; one department can have only one supervisor.

$1.$ Describe one insert anomaly caused by this database design.

$2.$ Describe one delete anomaly caused by this database design.

$3.$ In which normal form is this database $(3$NF$,2$NF$,1$NF or unnormalized$)?$

$4.$ Describe the lowest normal form violation and the field$($s$)$ involved.

$5.$ If this database is not $3$NF$,$ provide a solution schema that is $3$NF$.$