Normalization in DBMS is used to:
2026
Normalization in DBMS is used to:
Answer: B. Remove redundancy — ConceptDatabase normalization organizes relations according to normal forms so that each fact is stored in an appropriate place. Its central aim is to reduce…
- A.
Increase redundancy
- B.
Remove redundancy
- C.
Add columns
- D.
Delete records
Attempted by 487 students.
Show answer & explanation
Correct answer: B
Concept
Database normalization organizes relations according to normal forms so that each fact is stored in an appropriate place. Its central aim is to reduce unnecessary data duplication and the update, insertion, and deletion anomalies caused by that duplication.
Application
Here, “Remove redundancy” names that purpose. More precisely, normalization reduces avoidable redundancy; it does not guarantee that every duplicate value disappears.
Contrast
“Increase redundancy” means storing repeated facts in more places, which can increase inconsistency risk.
“Add columns” changes the attributes of a table; it is not the primary objective of normalization.
“Delete records” is a data-manipulation operation on rows, not a schema-design objective.
Therefore, the best offered answer is “Remove redundancy,” understood as reducing avoidable redundancy.