ITPEC IP October 2018 Question 28
ITPEC IP October 2018 — Question 28 of 100
Database normalization reduces redundant storage of facts and the inconsistencies that redundancy can cause. By separating data according to dependencies and linking related tables with keys, a fact can be maintained in one appropriate place, reducing update, insertion, and deletion anomalies.
Answer (c)
Why not others:
- hardware compatibility is not the purpose of relational normalization
- normalization reorganizes relationships rather than compressing byte representation
- normalized data still requires backups against failure and loss
Key rule: Normalize to represent each fact consistently and minimize dependency-related anomalies, while preserving relationships through keys.
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.