Question: Use the following business rules to create an ERD. Write all appropriate modality and cardinalities in the ERD. a . A department employs many employees,
Use the following business rules to create an ERD. Write all appropriate modality and
cardinalities in the ERD.
a A department employs many employees, but each employee is employed
by one department.
b Some employees, known as "rovers," are not assigned to any
department.
c A division operates many departments, but each department is
operated by one division.
d An employee may be assigned many projects, and a project may have
many employees assigned to it
e A project must have at least one employee assigned to it
f One of the employees manages each department, and each department
is managed by only one employee.
g One of the employees runs each division, and each division is run
by only one employee.
The Jonesburgh County Basketball Conference JCBC is an amateur
basketball association. Each city in the county has one team as
its representative. Each team has a maximum of players and a
minimum of players. Each team also has up to three coaches
offensive defensive, and physical training coaches During the
season, each team plays two games home and visitor against each
of the other teams.
Draw Crow's Foot ERDs to represent the JCBC database.
Draw your project group ERD.
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
