ITPEC IP October 2021 Question 27
ITPEC IP October 2021 — Question 27 of 100
Normalization reduces duplicate data and the inconsistencies that duplication can cause. By separating facts into appropriately related tables, a fact can be stored once and referenced where needed, reducing update, insertion, and deletion anomalies.
Answer (c)
Why not others:
- normalization does not provide compatibility between different computer types
- it reorganizes relational structure rather than compressing data
- normalized databases still require backups against device failure, corruption, or accidental deletion
Key rule: Database normalization organizes attributes according to dependencies so that each fact is represented consistently with minimal redundancy.
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.