Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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

Principles of Information Systems (MindTap Course List)
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter11: Knowledge Management And Specialized Information Systems
Section: Chapter Questions
Problem 18SAT
See similar textbooks
icon
Related questions
Question

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

 

 

Arena ArenaName IeamName State Seating Capacity ANN AANA AAAA Athletic Brand BrandName Most sold itemTeamName IeamName Соach ÇoachName Salary Years Coaching TeamName Team Year Establis hed TeamNa BrandNa Awar Ran Own Number_of_1stDraft Number of AllS me k er Pick tars Player PlayerNa Salar Positio Scho Majo | Hometo Assist Reboun Point Birthd TeamNa me y ol wn ds me n r ay
Transcribed Image Text:Arena ArenaName IeamName State Seating Capacity ANN AANA AAAA Athletic Brand BrandName Most sold itemTeamName IeamName Соach ÇoachName Salary Years Coaching TeamName Team Year Establis hed TeamNa BrandNa Awar Ran Own Number_of_1stDraft Number of AllS me k er Pick tars Player PlayerNa Salar Positio Scho Majo | Hometo Assist Reboun Point Birthd TeamNa me y ol wn ds me n r ay
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Database Development
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS