ITPEC IP October 2019 Question 27
ITPEC IP October 2019 — Question 27 of 100
Customers must contain both Employee code and Region code as foreign keys. Employee code joins to Employees in charge to obtain Employee name, and Region code joins to Regions to obtain Region name. Customer code remains the primary key, while Customer name and Representative name belong directly to the customer.
Answer (d)
Why not others:
- (a) has no keys for either join
- (b) can obtain the employee name but not the region name
- (c) can obtain the region name but not the employee name
Key rule: A table needs a foreign key for every independent referenced entity whose attributes must be joined into the result.
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.