ITPEC IP April 2022 Question 28
ITPEC IP April 2022 — Question 28 of 100
Normalization reduces data duplication and inconsistency so relational data is easier to maintain. It separates data into appropriately structured tables based on dependencies. Storing each fact in one suitable place helps prevent update anomalies, such as changing one duplicate value but leaving another copy unchanged, as well as insertion and deletion anomalies.
Answer (b)
Why not others:
- (a) normalization removes unnecessary redundancy rather than deliberately adding it
- (c) unifying character encodings is a data representation issue, not normalization
- (d) compression reduces storage size but does not restructure functional dependencies
Key rule: Database normalization organizes attributes by their dependencies to minimize redundancy and prevent modification anomalies.
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.