ITPEC IP April 2020 Question 27
ITPEC IP April 2020 — Question 27 of 100
Normalization eliminates unnecessary duplication and the data inconsistencies it can cause, making relational data easier to maintain. Facts are separated into related tables according to their dependencies so that one fact is not repeatedly stored in many places.
Answer (b)
Why not others:
- normalization reduces redundancy rather than deliberately adding it
- it does not standardize character encoding
- it restructures tables and is not a lossless compression algorithm
Key rule: Normalization reduces update, insertion, and deletion anomalies by representing each fact in an appropriate relational structure.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.