Normalization in DBMS is used to:

2026

Normalization in DBMS is used to:

Answer: B. Remove redundancyConceptDatabase normalization organizes relations according to normal forms so that each fact is stored in an appropriate place. Its central aim is to reduce…

  1. A.

    Increase redundancy

  2. B.

    Remove redundancy

  3. C.

    Add columns

  4. 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.

Explore the full course: Niacl Ao It Specialist

Loading lesson…