Consider the following relation that holds data about employee assignments:

ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName,

HoursWorked)

Assume that ProjectNumber determines ProjectName and explain why this relation

is not normalized. Demonstrate an insertion anomaly, a modification anomaly,

and a deletion anomaly. Apply the normalization process to this relation. State the

referential integrity constraint.