What is the main objective of database normalization?

Options

  • A. To increase unnecessary data duplication
  • B. To reduce data redundancy and update anomalies
  • C. To eliminate all database tables
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. To reduce data redundancy and update anomalies

Detailed Explanation

  • Normalization: Organizes data into well-structured relations.
  • It reduces unnecessary duplication of data.
  • It helps prevent insertion, update and deletion anomalies.