ITPEC IP October 2020 Question 27
ITPEC IP October 2020 — Question 27 of 100
Normalization analyzes dependencies among fields and decomposes tables to reduce duplication and prevent update inconsistencies. Properly normalized relations store each fact in an appropriate place, avoiding anomalies during insertion, modification, and deletion.
Answer (c)
Why not others:
- a join combines related rows from tables for a query
- projection selects particular columns from a relation
- exclusive control coordinates concurrent access so conflicting updates do not occur
Key rule: Normalization is a design activity; joins and projections are data operations, while exclusive control manages concurrency.
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.