~/ learn/ comp-378/ cards/ Well-Structured Relations & the Three Anomalies
1 of 3

Type the well-structured split that removes the anomalies

Type the well-structured split that removes the anomalies

Answer

EMPLOYEE(EmpID, Name, DeptName, Salary) EMP_COURSE(EmpID, CourseTitle, DateCompleted)

Splitting employee facts from course facts means each employee's salary lives in exactly one place (no update anomaly), a course-less employee can be added (no insertion anomaly), and removing a course row no longer erases the employee (no deletion anomaly).

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/f60c9a7a-44f6-425b-954d-bd2a4d92737f/flashcard utf-8 LF