The update anomaly in file-based systems or unnormalized 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 in file-based systems or unnormalized database tables occurs because of data redundancy. When the same data is duplicated across multiple records, updating that data requires changing all instances, which can lead to inconsistencies and errors.

The Update Anomaly in File-Based Systems or Unnormalized Database Tables