Pojectnumber determines projectname and explain why this


Consider the following table, which holds data about employee project 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

Request for Solution File

Ask an Expert for Answer!!
Business Management: Pojectnumber determines projectname and explain why this
Reference No:- TGS0659016

Expected delivery within 24 Hours