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.
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.
b. Identify the connectivity and cardinality of each of the relationship.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here