Question
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD.
a). A company has many divisions. Each division operates many departments, but each department is operated by one division.
b). A department employs many employees but not more than 100.
c). Each employee is employed by one department.
d). Some employees, known as rovers, are not assigned to any department.
e). An employee may be assigned to many projects.
f). A project may or may not have one or more employees assigned to it. The number of employees assigned to a project can not exceed five people.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started