ITPEC FE Morning October 2023 Question 26
ITPEC FE Morning October 2023 — Question 26 of 80
Normalization — the method used to remove data redundancy in relational databases.
Normalization decomposes tables into smaller ones to eliminate duplicate data, using normal forms (1NF → 2NF → 3NF → BCNF).
Why not others:
- (a) Entity-relationship — a data modeling technique (ER diagrams), not a redundancy removal method
- (b) Functional dependency — a concept (A → B) used during normalization, but not the method itself
- (c) Hierarchical — a type of database model, unrelated to removing redundancy
Key distinction: Functional dependency is the criterion; normalization is the process that applies it.
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 FE past-paper collection or Report an issue.