The update anomaly in non-normalized database tables
A)occurs because of data redundancy.
B)restricts addition of new fields or attributes.
C)results in records that cannot be updated.
D)is usually easily detected by users.

Question

Quizplus · Accepted Answer

The update anomaly occurs in non-normalized database tables because of data redundancy. Data redundancy refers to having the same piece of data stored in multiple places in a database, which can lead to inconsistencies and errors when trying to update that data. Normalization is the process of minimizing data redundancy in a database, which can help prevent update anomalies from occurring.

The Update Anomaly in Non-Normalized Database Tables