ITPEC FE Subject A April 2024 Question 19
ITPEC FE Subject A April 2024 — Question 19 of 60
ER Model Arrow Notation — interpret one-to-many relationships from arrow direction.
In this ER diagram: Department → Employee → Dependent
- •Arrow means one-to-many in the direction of the arrow
- •
Department → Employee— one department has many employees - •
Employee → Dependent— one employee has many dependents
Answer: (a) — A department has many employees, and employees can have multiple dependents.
Why not others:
- (b) — says "exactly one dependent" per employee, but the arrow shows one-to-many
- (c) — "at most one" dependent contradicts the one-to-many arrow
- (d) — the arrow from Department to Employee means each employee belongs to one department, not two
Key rule: Arrow from A → B means "one A has many B" (one-to-many in arrow direction).
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 FE past-paper collection or Report an issue.