Design a logical ERD for the following case study. Use the Crow's Foot notations in your designed ERD. Case study: • Acme Pty Ltd is made up of a number of departments that manage none or more projects. Each project belongs to a department. • Each department employs a number of employees. Each employee works in one department. • A team of employees work on each project. Some employees may not be assigned to any project yet and a new project may not have any team assigned to it. One of the team members supervises the other team members on the project. In particular, in the ERD you need to show: 1. All entities with their attributes, including PK and FK attributes 2. Relationship (with name) between entities, and 3. Connectivity and participation between entities.

icon
Related questions
Question
Design a logical ERD for the following case study. Use the Crow's Foot notations in your
designed ERD.
Case study:
• Acme Pty Ltd is made up of a number of departments that manage none or more
projects. Each project belongs to a department.
• Each department employs a number of employees. Each employee works in one
department.
• A team of employees work on each project.
Some employees may not be assigned to any project yet and a new project may not
have any team assigned to it.
One of the team members supervises the other team members on the project.
In particular, in the ERD you need to show:
1. All entities with their attributes, including PK and FK attributes
2. Relationship (with name) between entities, and
3. Connectivity and participation between entities.
Transcribed Image Text:Design a logical ERD for the following case study. Use the Crow's Foot notations in your designed ERD. Case study: • Acme Pty Ltd is made up of a number of departments that manage none or more projects. Each project belongs to a department. • Each department employs a number of employees. Each employee works in one department. • A team of employees work on each project. Some employees may not be assigned to any project yet and a new project may not have any team assigned to it. One of the team members supervises the other team members on the project. In particular, in the ERD you need to show: 1. All entities with their attributes, including PK and FK attributes 2. Relationship (with name) between entities, and 3. Connectivity and participation between entities.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer