Each salesperson has one office and only one salesperson is assigned to each office. An office can have

only one computers and every computer is assigned to only one office.

$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$.$