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 Jonesburgh High School, Pepsi Center, etc.) and the address.
1) Convert the ERD to the relational tables using MySQL Server
2) 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
I am sorry I forgot to convert them to relational tables
Tables | Satisfy the 1NF? | 2NF? | 3NF? | How would you fix it if it is against any NFs? |
Table1 | ||||
T.2 | ||||
I am stuck on number 3 any guidance would be great
Coaches Team Games PK CoachID TeamID PK Gameld FName Name Name LName City + CityID Contact + Descrip Date/Time DOB Address Email CoachType TeamID - Vistior Team Home Team Players PK TeamlD PK TeamID PK PlayerID TeamNumer TeamNumer FName Row 2 Row 2 LName Row 3 Row 3 Email Contact Gender Address Games GameID INT Name VARCHAR(45) Team Team ID INT Name VARCHAR(45) City VARCHAR(45) Description VARCHAR(45) Teamcol VARCHAR(45) 0 Coaches Coach ID INT FName VARCHAR(45) LName VARCHAR(45) Contact VARCHAR(45) DOB VARCHAR(45) >t Address VARCHAR(45) Email VARCHAR(45) Coach Type VARCHAR... Team_TeamID INT Indexes + Indexes 0 Indexes Coaches_has_Players Coaches_CoachID INT Players_PlayerID INT Indexes Players PlayerID INT FirstName VARCHAR(45) LastName VARCHAR(45) Email VARCHAR(45) # Contact VARCHAR(45) Gender VARCHAR(45) Address VARCHAR(45) Team_TeamID INT Indexes
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