Question: Task 1 : Create a Crow's Foot ER diagram for the following business Rules. Write all appropriate connectivities and cardinalities in the ERD. Create a
Task : Create a Crow's Foot ER diagram for the following business Rules.
Write all appropriate connectivities and cardinalities in the ERD. Create a data
dictionary by adding some attributes to each entity.
A department employs many employees, but each employee is employed
by one department.
Some employees, known as "rovers," are not assigned to any department.
A division operates many departments, but each department is operated by
one division.
An employee may be assigned many projects, and a project may have many
employees assigned to it
A project must have at least one employee assigned to it
One of the employees manages each department, and each department is
managed by only one employee.
One of the employees runs each division, and each division is run by only
one employee.
Task : Create an SQL file based on the ER diagram you Created in task and
add a minimum of records for each entity in the database:
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
