Answer to Question #76077 in Databases | SQL | Oracle | MS Access for Jonny

Question

A EMPLOYEE relation has the following attributes: EmployeeID, EmployeeName, BirthDate, CourseID, CourseTitle, DateCompleted

There is one row for each Course completed by an employee. There is currently one employee that completed the Security course.

What type of anomaly would surface if that employee row were removed?



Addition Anomaly


Deletion Anomaly


Update Anomaly


Insertion Anomaly

Answer 1

Remove of given row causes deletion anomaly.