ITPEC IP October 2022 Question 28
ITPEC IP October 2022 — Question 28 of 100
Option (a) properly separates customers, products, and orders using stable numeric keys. Customer attributes depend on CustomerNumber, product attributes depend on ProductNumber, and each order stores references to those entities plus quantity and date. Duplicate customer or product names do not cause ambiguity because relationships use their unique numbers.
Answer (a)
Why not others:
- (b) relates orders by nonunique names
- (c) mixes customer, order, and product attributes and omits a product master
- (d) puts order quantity in Product and repeats customer details in Order
Key rule: Normalization stores each fact with the key it depends on and connects entities using primary and foreign keys, not nonunique names.
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.