ITPEC IP October 2023 Question 26
ITPEC IP October 2023 — Question 26 of 100
The Employee table needs both Department_code and Location_code as foreign keys. Joining Department_code to the Department table supplies Department_name, while joining Location_code to the Location table supplies Location_name. The Employee table already supplies Employee_number, Employee_name, and Age, producing every column shown in result table A.
Answer (d)
Why not others:
- (a) has neither foreign key, so neither descriptive name can be joined
- (b) can obtain Location_name but has no key for Department_name
- (c) can obtain Department_name but has no key for Location_name
Key rule: A join requires matching attributes: each referenced master table needs its corresponding foreign key in the related row.
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.