CAPE Computer Science Unit 2 · 2012 · Paper 2 · Question 4(a)(ii)

A software company undertakes projects consisting of tasks requiring various skills. The company records employee details (first name, last name, address, phone number, unique employee number). Each employee has multiple competencies, which may overlap with others. Employees can be assigned to only one project, but to one or more tasks based on competencies.

Draw an entity-relationship model for the described software project and employee scenario.