Which technique is commonly used to reduce unnecessary data duplication in relational databases?

Options

  • A. Normalization
  • B. Data replication
  • C. Data encryption
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. Normalization

Detailed Explanation

  • Normalization: Organizes database tables to reduce unnecessary redundancy.
  • It separates related information into properly structured relations.
  • It helps prevent insertion, deletion and update anomalies.