ITPEC FE Morning April 2023 Question 28

Source exam: ITPEC FE Morning April 2023Topic: Databases

ITPEC FE Morning April 2023 — Question 28 of 80

UML Multiplicity in Conceptual Data Models — interpret association multiplicity between classes.

Given: Department 1..* ◄ Belongs to ── 0..* Employee

Reading multiplicity from each side:

  • `1..*` near Department → each Employee belongs to one or more Departments
  • `0..*` near Employee → each Department has zero or more Employees

Interpretation:
- An employee can belong to multiple departments simultaneously

- A department can exist without any employees

- An employee must belong to at least one department

Why not others:
- (a) Wrong — 0..* on Employee side means a department CAN have zero employees

- (c) Wrong — 1..* on Department side means an employee MUST belong to at least one department

- (d) Wrong — nothing in the diagram constrains total counts to be equal

Key rule: Read multiplicity on the opposite end of the association — 1..* near Department describes how many Departments one Employee relates to.

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.