Question

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 3 coaches (offensive, defensive, and physical training coaches). During the season, each team plays 2 games (home and visitor) against each of the other teams. Given those conditions, do the following:

• Draw the Chen and Crow’s Foot ERDs to represent the JCBC database.

• Draw the UML class diagram to depict the JCBC database.

Answer 1

Draw the Chen and Crow’s Foot ERDs to represent the JCBC database.

E-R Diagram-

• This Er model has 4 main entities-

1. Team
2. PLayers
3. Game
4. Coaches

• This Er model has has been converted into 3NF
• Here each entity and its attributes are in tabular form
• Data types of each attribute has been mentioned with it
• The primary key as PK and foriegn key as FK has been mentioned there.
  

• Draw the UML class diagram to depict the JCBC database

UML Class diagram-

classes:

1. team
2. coaches
3. game
4. players

attributes-

1. teamID:int = defaultValue
2. Name:varchar
3. city:varchar
4. description:varchar
5. gamesID: = defaultValue
6. Name: + City:
7. DateTime:DateTime
8. HomeTeam
9. Visitor Team
10. coachesID: int = defaultValue
11. First name: varchar
12. Last name: varchar
13. Contact: int
14. date of birth: date
15. address: varchar
16. Email:varchar
17. coach type: varchar
18. playersID: int = defaultValue
19. First name: varchar
20. Last name: varchar
21. Contact: int
22. date of birth: date
23. address: varchar
24. Email:varchar

methods-

1. teamname()
2. city()
3. game()
4. team()
5. coach()
6. players()

If any doubt, please feel free to ask and comment, i would like to answer them.
Thank you