Which anomaly occurs when a new fact cannot be inserted into a table without adding unrelated 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)

A. Insertion anomaly

Detailed Explanation

  • Insertion anomaly: Occurs when a fact cannot be inserted independently because of the table structure.
  • It may force users to enter unrelated or unavailable information.
  • Proper normalization helps eliminate this problem.