What is the main purpose of database normalization?

Options

  • A. To increase data redundancy
  • B. To reduce data redundancy and avoid anomalies
  • C. To increase duplicate records
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. To reduce data redundancy and avoid anomalies

Detailed Explanation

Explanation: Normalization organizes database tables to minimize unnecessary data redundancy and prevent insertion, deletion and update anomalies.