ITPEC FE Morning October 2020 Question 27

UML Multiplicity in ER Data Model — determine multiplicity between Department, Assignment history, and Employee.

Conditions:
- One or more employees belong to a department → every department has ≥1 assignment record
- An employee belongs to any one department → every employee has ≥1 assignment record
- Department assignment history is recorded with start/end dates

Blank I (Department → Assignment history):
- Condition (1) guarantees every department has at least one employee
- Multiple employees possible → 1..*

Blank II (Employee → Assignment history):
- Condition (1) requires every employee to belong to a department
- Employee may transfer between departments → 1..*

Answer: (d) — I = 1..*, II = 1..*

Why not others:
- (a) 0..*, 0..* — violates condition (1): both sides require at least one record
- (b) 0..*, 1..* — Blank I wrong: condition (1) guarantees every department has employees
- (c) 1..*, 0..* — Blank II wrong: every employee must belong to at least one department

AI-generated — may contain errors