ITPEC IP October 2019 Question 28
ITPEC IP October 2019 — Question 28 of 100
Employee master data should be separated from examination results and linked by Employee ID. The employee table stores Employee ID, name, and date of birth once. The result table stores Employee ID with examination category, date, and outcome for each attempt.
Answer (a)
Why not others:
- (b) links results by employee name, which is not unique
- (c) mixes examination dates into employee master data and repeats employee names in results
- (d) omits employee name from the master and examination date from the result table
Key rule: Normalize stable employee attributes into one table and repeating event facts into another, joined by a unique identifier rather than a name.
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.