Which of the following anomalies can occur in a poorly normalized database?

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)

D. More than one of the above

Detailed Explanation

  • Insertion anomaly: Difficulty inserting data without unrelated information.
  • Deletion anomaly: Deleting one record may unintentionally remove other useful information.
  • Update anomaly: The same information may need to be updated in multiple places.
  • Normalization helps reduce all these anomalies.