The update anomaly in unnormalized databases
A)occurs because of data redundancy
B)complicates adding records to the database
C)may result in the loss of important data
D)often results in excessive record insertions

Question

Quizplus · Accepted Answer

The update anomaly is caused by data redundancy, which can result in inconsistencies, contradictory or duplicate data. This can cause problems when updating or modifying a database, because changes made to one instance of data do not automatically propagate to other instances. It can also complicate the process of adding new records to the database, resulting in excessive record insertions. Furthermore, the update anomaly can lead to loss of important data, since modifications made to one set of data may not be reflected in other sets.

The Update Anomaly in Unnormalized Databases