CAPE Computer Science Unit 2 · 2015 · Paper 2 · Question 4(d)

In a company, employees are assigned to a single department, and each department is managed by a manager who may manage more than one department. Each department has supervisors who may supervise one or more employees. Each employee has a unique employee ID (primary key), name, address, job title, next of kin, and emergency contact number.

Draw an entity-relationship (ER) model for the company scenario, naming relationships and clearly indicating cardinality and all given attributes.