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.