Question: A software company would like to store information regarding the EMPLOYEES (such as Graphic Designers, Project Managers and Software Engineers) and PROJECTs. The company will

A software company would like to store information regarding the EMPLOYEES (such as Graphic Designers, Project Managers and Software Engineers) and PROJECTs. The company will store the following attributes for all EMPLOYEEs: a unique employee id, an employee name, the date the employee started working for the company, the number of years on the job, the salary, and the programming languages in which he/she is fluent (eg: Java, AJAX, .net). For Graphic Designers in particular, the company will also store the number of years of experience with Adobe Creative Suite. For Project Managers in particular, the company will also store all certifications (SCRUM Master, Project Management Professional, etc.). An employee may be employed as a Graphic Designer and a Project Manager at the same time.

For every PROJECT, they will store a unique project ID, and a project title. Within a PROJECT, a MODULE can be uniquely identified by its module id. All PROJECTs will have at least one MODULE. Every MODULE belongs to exactly one PROJECT.

Every EMPLOYEE is assigned to at least one PROJECT. Most PROJECTs will have more than one EMPLOYEE working for it, but some new PROJECTs have no EMPLOYEEs working on them. The date that an EMPLOYEE is assigned to a PROJECT is also recorded

Design an EER database diagram for the date given above using associative entities when needed .

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!