Question: Question # 3 Full ER Diagram: A software development consulting company is creating a new database to track their consulting projects based on the following
Question # Full ER Diagram: A software development consulting company is creating a new database to track their consulting projects based on the following design requirements:
There are types of employees in the consulting company: project manager, developer, and UIUX designer. Each employee is one of these types. Every employee has a name first and last a unique company email, and a salary. The database maintains a developer's github username unique experience level entrylevel, junior, senior, principal and or more programming languages in which they are proficient.
Every UIUX designer consults with a single project manager in the company on all their designs. Not all managers will have a UIUX designer because they may only work on backend projects.
Customers are identified by their company name and the state in which they reside. Each customer has contact information, that includes a company contact name first and last and phone number. They can also include email addresses.
When a company signs a contract for a specific project, the project is assigned a project number specific to the company. The total budget for the project is specified. For billing purposes, the combined number of developers and managers who worked on the project over its duration is tracked.
Every project is assigned manager to oversee the project. The total number of projects currently assigned to each manager is stored.
Each project requires at least one developer. Developers are assigned to multiple projects at a time based on their experience level and the programming languages that they know, but no more than projects at a time. The date month and year the developer starts and ends on a project is tracked.
A developer can be mentored by at most other developer, but a developer can be a mentor to many.
Based on the description above, draw the complete ER diagram.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
