ITPEC IP October 2025 Question 27
ITPEC IP October 2025 — Question 27 of 100
Product_number — it is the Product table's primary key and the Purchase table's foreign key linking each purchase to its product.
Product-specific facts such as Product_name and Unit_price belong in Product and are located through Product_number. Purchase retains Product_number together with purchase-specific facts such as count, payment method, and delivery date.
Answer (c)
Why not others:
- (a) Purchase_number identifies a purchase and need not appear in Product
- (b) Payment_method describes the purchase only
- (d) Product_name is descriptive and may change or duplicate; it is not the stated unique product identifier
Key rule: In a one-product-per-purchase relationship, store the product primary key as a foreign key in each purchase record.
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.