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).