Question: The following E / R diagram is being designed for the database for project management. Members of the project team, projects, and project execution offices
The following ER diagram is being designed for the database for project management. Members of the project team, projects, and project execution offices are related to work, which is a fourparty relationship.
Add the meaning "Members belong to only one team and teams work on multiple projects with multiple members" to the ER diagram.
We want to give the meaning that "each team carries out a project in one office and the office is shared by multiple teams." Correct the ER diagram that you modified in No
Add the meaning "one office is associated for each member and project combination" to the ER diagram revised in No
In the ER diagram revised in No add the meaning "Express members as managers PM programmers, HW operations, server management, etc., and the manager manages one team and several projects. Also, each team has one manager."
Suppose that the name of the project is expressed in letters between A and Z What problems can arise if the number of projects being carried out at the same time is more than How can we modify the above ER diagram to solve this problem?
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
