Which anomaly occurs when deleting one record unintentionally removes other useful information?

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)

B. Deletion anomaly

Detailed Explanation

  • Deletion anomaly: Occurs when deleting a record also removes information that should have been retained.
  • It is common in poorly designed and highly redundant tables.
  • Normalization helps separate independent facts into appropriate relations.