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.
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.
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images