Exercise No. 10: Project Management
Transfer the following verbal description into an ERM
a) A project (Proj-#) consists of several work packages (WP-#).
b) Work packages are structured into a hierarchical work breakdown structure, whereby a work package can be subdivided into several further work packages, while each work package is subordinated to exactly one work package.
c) One or more employees (SI-ID) are assigned to each work package, whereby employees can also be employed in several work packages. Employees have certain qualifications (Qual-ID) and are uniquely assigned to departments (Dept-ID).
d) A work package can require one or more qualification.
e) Each project has an employee as a responsible person; however an employee can also have responsibility for several projects.