ITPEC IP April 2019 Question 28
ITPEC IP April 2019 — Question 28 of 100
The normalized design separates customers, products, and orders and links them through stable numeric identifiers. In (a), CustomerNumber determines customer name and address, ProductNumber determines product name and unit price, and each order stores the relevant identifiers with quantity and date. Duplicate names cause no ambiguity because names are not used as keys.
Answer (a)
Why not others:
- (b) stores non-unique customer and product names in ORDER instead of their identifiers
- (c) mixes order date with customer data and repeats product facts in orders
- (d) puts order-specific quantity in PRODUCT and does not properly separate customer data
Key rule: Place facts with the entity they describe and connect entities by primary and foreign keys rather than non-unique 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.