A deletion anomaly exists when deleting data about one entity results in the loss of data about another entity.

Question

Quizplus · Accepted Answer

A deletion anomaly occurs when deleting data about one entity leads to the loss of data about another entity that is related to the first entity. This can occur in a poorly designed database where the deletion of a row in one table affects the existence of the same data in another table that relies on that data.

A Deletion Anomaly Exists When Deleting Data About One Entity