ITPEC IP April 2026 Question 26
ITPEC IP April 2026 — Question 26 of 100
Elimination of data redundancy and inconsistency — normalization separates facts into related tables so each fact is stored in the proper place.
Repeated attributes are removed and dependencies are represented through keys. This prevents update anomalies, such as changing one copy of an address while another copy remains old.
Answer (c)
Why not others:
- (a) compatibility between computer types comes from standards and software, not normalization
- (b) normalization is logical restructuring, not data compression
- (d) normalized databases still require backups against loss or hardware failure
Key rule: Normalize to reduce duplication and insert, update, and delete anomalies; backup and compression solve different problems.
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.