Which of the following best describes the primary purpose of database normalization?
- Increasing data integrity
- Maximizing redundancy and dependency
- Minimizing redundancy and dependency
- Simplifying data retrieval
Database normalization primarily aims to minimize redundancy and dependency in a database schema, leading to improved data integrity and reducing anomalies such as update, insertion, and deletion anomalies.
Loading...
Related Quiz
- What is a covering index in a database?
- HBase is a distributed, ________ database that runs on top of Hadoop.
- What is the role of a Data Protection Officer (DPO) in an organization?
- Why is it important to involve stakeholders in the data modeling process?
- What is denormalization, and when might it be used in a database design?