Please don not reject. It is not graded TABLE 5.36 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. TABLE 5.37 ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName, HoursWorked) Assume that ProjectNumber determines ProjectName, and explain why this relations not normalized. Demonstrate an insertion anomaly, a modification anomaly,and a deletion anomaly. Apply the normalization process to this relation. State thereferential integrity constraint. QUESTION Explain the difference between the two ASSIGNMENT tables in exercises 5.36 and 5.37. Under what circumstances is the table in exercise 5.36 more correct? Under what circumstances is the table in exercise 5.37 more correct?
Please don not reject. It is not graded
TABLE 5.36
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.
TABLE 5.37
ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName, HoursWorked)
Assume that ProjectNumber determines ProjectName, and explain why this relations not normalized. Demonstrate an insertion anomaly, a modification anomaly,and a deletion anomaly. Apply the normalization process to this relation. State thereferential integrity constraint.
QUESTION
Explain the difference between the two ASSIGNMENT tables in exercises 5.36 and 5.37. Under what circumstances is the table in exercise 5.36 more correct? Under what circumstances is the table in exercise 5.37
more correct?
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
