Can sme one explain hot to normalize these tables into 2NF? Table Name: Arena This table is used to store arena name, team name, state and seating capacity details. Foreign key: Not present Unique Key : AreanaName Table Name: Athletic Brand This table is used to store Athletic Brand information. This table contains Brand Name, Most _sold _Item Team Name and Team Name Foreign key: TeamName Unique Key: BrandName Table Name: Coach This table is used to store Coach information. This table contains Coach Name, Salary, Years of Coaching and Team Name Foreign key: Team Name Unique Key: Not Present Table Name: Team This table is used to store Team information. This table contains Team Name, Brand Name, Years Established, Award, Rank Owner, Number of 1st Draft Pick and Number of all the stars Foreign key: brandName, Unique Key: Team Name Table Name: Player This table is used to store Player information. This table contains Player Name, Salary, Position, School, Major, Hometown, Assist Rebounds, points, Birthday, TeamName. Foreign key: TeamName, Unique Key: Not Present
Can sme one explain hot to normalize these tables into 2NF?
Table Name: Arena
This table is used to store arena name, team name, state and seating capacity details.
Foreign key: Not present
Unique Key : AreanaName
Table Name: Athletic Brand
This table is used to store Athletic Brand information. This table contains Brand Name, Most _sold _Item Team Name and Team Name
Foreign key: TeamName
Unique Key: BrandName
Table Name: Coach
This table is used to store Coach information.
This table contains Coach Name, Salary, Years of Coaching and Team Name
Foreign key: Team Name
Unique Key: Not Present
Table Name: Team
This table is used to store Team information.
This table contains Team Name, Brand Name, Years Established, Award, Rank Owner, Number of 1st Draft Pick and Number of all the stars
Foreign key: brandName,
Unique Key: Team Name
Table Name: Player
This table is used to store Player information.
This table contains Player Name, Salary, Position, School, Major, Hometown, Assist Rebounds, points, Birthday, TeamName.
Foreign key: TeamName,
Unique Key: Not Present
Step by step
Solved in 2 steps