Scenario: A company has employees and departments. Each employee must be assigned to one department, but a department can have multiple employees. What cardinality and modality does this scenario represent?

  • Many-to-Many, Optional
  • Many-to-One, Mandatory
  • One-to-Many, Mandatory
  • One-to-One, Optional
This scenario represents a One-to-Many relationship with mandatory modality. Each department can have multiple employees (Many), while each employee must be assigned to one department (One). The modality is mandatory because every employee must be assigned to a department.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *