ITPEC FE Subject A October 2024 Question 19
ITPEC FE Subject A October 2024 — Question 19 of 60
ER Diagram Multiplicity — match business rules to correct cardinality notation.
Given conditions:
- Employee is associated with 1 program; a program has at least one employee
- A program belongs to 1 college; a college has one or many programs
Required relationships:
- College 1..1 ——— 1..* Program → one college has many programs
- Program 1.1 ——— 1..* Employee → one program has many employees
How to read multiplicity: the number next to an entity shows how many instances of that entity participate in the relationship.
Why not others:
- (a) — reverses Employee–Program direction: gives employee many programs, program one employee
- (c) — College 1..* to Program 1.1 means one program per college — contradicts "one or many programs"
- (d) — Program–College is 1.1–1.1 (one-to-one) and College–Employee is direct — wrong structure
Key rule: Always read the multiplicity from each entity's perspective: the number next to an entity = how many of that entity exist in the relationship.
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.