CONSIDER THE FOLLOWING DATABASE:

MANAGER$-$INFO $($MGR$-$ID$,$ MGR$-$NAME, OFFICE#$,$ TELEPHONE#$,$ PROJECT#$,$ PROJECT$-$NAME$)$

Each manager has an office and there is only one manager in an office. An office has one phone andeach phone serves only one office. One manager can have more than one project, but there is only one

manager per project.

$1.$ Describe one insert anomaly caused by this database design. $[$Be VERY specific, i$.$e$.$X data can$$t be added without first adding Y data$]$

$2.$ Describe one delete anomaly caused by this database design. $[$Be VERY specific, i$.$e$.$When X data is deleted, Y data may also be lost$.]$

$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. $[$Normal form violations arerepeating groups, partial dependencies, or transitive dependencies. Be very specific about

which field repeats, or which field is partially or transitively dependent on which other field.$]$

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