~/ 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/25a863d9-3b1e-4cab-8e56-cdbcd17058da/flashcard utf-8 LF