When describing relational tables use this format for the schema of the relation: Table Name

$($Primary Key, Field, Field, Field$*)$ where the primary key field$($s$)$ is$($are$)$ underlined and an asterisk

indicates any foreign key. Each of these problems is independent of the others.

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

each 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 are

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