ITPEC IP October 2022 Question 27
ITPEC IP October 2022 — Question 27 of 100
The Customers table must contain both Employee code and Region code as foreign keys. Table A includes Employee name and Region name, but those descriptive fields originate in two separate master tables. Joining Customers to Employees in charge requires Employee code, and joining it to Regions requires Region code.
Answer (d)
Why not others:
- (a) has neither key and cannot join either master table
- (b) can obtain employee name but not region name
- (c) can obtain region name but not employee name
Key rule: A table needs a foreign key for each independent referenced master table whose attributes must be retrieved.
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.