Which type of anomaly occurs when the same information must be modified in multiple records?

Options

  • A. Insertion anomaly
  • B. Deletion anomaly
  • C. Update anomaly
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. Update anomaly

Detailed Explanation

  • Update anomaly: Occurs when duplicated information must be changed in multiple records.
  • If some copies are not updated, inconsistent data may result.
  • Normalization reduces this problem by organizing data into related tables.