Which of the following anomalies result from a transitive dependency?
A) Insertion
B) Modification
C) Deletion
D) All of the above

Question

Quizplus · Accepted Answer

Transitive dependency results in all of the mentioned anomalies- insertion, modification, and deletion. Insertion anomaly occurs when a new record cannot be added to a table without including data that does not belong in the record but on which the record depends. Modification anomaly occurs when a change in a non-key attribute leads to inconsistencies because the change needs to be made in several places. Deletion anomaly arises when deleting a row would result in losing information that is still required elsewhere in the table.

Which of the Following Anomalies Result from a Transitive Dependency