Question
The Jonesburgh County basketball Conference (JCBC) is an amateur basketball association each citing in the county has one team as its representative. Each team has
The Jonesburgh County basketball Conference (JCBC) is an amateur basketball association each citing 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 the conditions do the following.
- Each player has a unique number in a certain team, name, contact information, and playing history (e.g., from when to when playing which position), assuming each player can only play for one team.
- Each city has a code, name, and abbreviation.
- Each team has a code, a name, starting date, and winning history (team position)
- Each coach has a number, name, role, and contact information, assuming one coach can only work for one team.
- Each coach can work for more than one role (offensive, defensive, and physical training coaches) at the same time. Offensive and defensive coach need to record the coach certified level while physical training coach needs to record the available time shift (e.g., MW vs. TTh).
- Each game has a code, two teams, points, timeouts, date, start and end time, and location including both the name (such as Summit High School, Pepsi Center, etc.) and the address.
1. Develop an ERD (Entity-Relationship Diagram) for the above case using Draw.io
2. Convert the ERD to the relational tables using MySQL Server
3. What are the 3NFs (three Normal Forms) ? Does each individual relational table satisfy the 3NFs? How would you fix the problem if not? Explain it in the following table (or any format your prefer) and make changes on Q.2 if necessary
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started