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 E/R 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 four-party relationship.
1. Add the meaning "Members belong to only one team and teams work on multiple projects with multiple members" to the E/R diagram.
2. 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 E/R diagram that you modified in No.1.
3. Add the meaning "one office is associated for each member and project combination" to the E/R diagram revised in No.2.
4. In the E/R diagram revised in No.3, add the meaning "Express members as managers (PM), programmers, H/W operations, server management, etc., and the manager manages one team and several projects. Also, each team has one manager."
5. Suppose that the name of the project is expressed in 26 letters between A and Z. What problems can arise if the number of projects being carried out at the same time is more than 26? How can we modify the above E/R diagram to solve this problem?
The following E / R diagram is being designed for

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 Programming Questions!