1. Draw the Crow’s Foot solution of the business rules given below: A driver may receive many (driving) assignments. Each (driving) assignment is made for a single driver. A truck may be driven in many (driving) assignments. Each (driving) assignment is made for a single truck 2. 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 12 players and a minimum of 9 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 other team. a. Draw the Crow’s Foot ERD to represent the JCBC database.
Write a relational mode for each of the case below. You can create our own attributes and provide common attributes to determine the link between tables.
1. Draw the Crow’s Foot solution of the business rules given below:
A driver may receive many (driving) assignments.
Each (driving) assignment is made for a single driver.
A truck may be driven in many (driving) assignments.
Each (driving) assignment is made for a single truck
2. 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 12 players and a minimum of 9 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 other team.
a. Draw the Crow’s Foot ERD to represent the JCBC
b. Identify the connectivity and cardinality of each of the relationship.
3. Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using at least the following business rules:
a. A patient can make many appointments with one or more doctors I the clinic, and a doctor can accept appointments with many patients. However, each appointment is made only with one doctor and one patient.
b. If kept, an appointment yields a visit with the doctor specified in the appointment.
c. With each visit, the patient’s records are updated to provide a medical history.
d. Each patient visit creates a bill. Each patient visit is billed by one doctor and each doctor can bill many patients.
e. Each bill must be paid. The payment maybe paid on different payment mode.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 10 images