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
Get step-by-step solutions from verified subject matter experts
