[Solved] Normalize Datebase Describe Bottom Page 2 1nf 2nf 3nf Q37177100
Can you this normalize this datebase as it describe at thebottom of page 2? 1NF, 2NF, AND 3NF
Team number (TeamNo) Player number (PlayerNo)an integer that identifies a playe Scorel (Scorel) Score2 (Score2) Score3 (Score3) an integer that identifies a team such as team number 1 is the Strikers r uniquely within the league bowling score of game number 1 such as 167 bowling score of game number 2 bowling score of game number 3 there are 15 weeks in the league. This data item will represent the week number being eek number (WeekNo) played so for the first scheduled meeting it would be recorded as week number 1. Player phone (PhoneNo) Player Name (PlayerName) Player Gender (Gender) Team name (Team Name) Team captain (Captain) Cell phone number of a player. First and last name of player. Gender of player. 1 for male, 2 for female. There are 4 players to a team. Each team will select a team name. Each team selects one player to represent the team captain. Hint: Remember how the supervisor was recorded in the Employees table from the Northwind database Email account of a player Player email (Email) The following is an example of possible data values for most of the data elements described above… Team no. Player No. Name Score Score 2 Score 3 Week No Phone Team Name 222-555 Strikers 1 333-5555 Strikers 1 333-5555 Strikers 150 160 145 170 180 177 150 165 170 60 162 15 oe Sue P Lou M. Donna S 200 80 19 233-8888 Hard Hitters 444-5555 Hard Hitters 2 222-5555 Strikers 2 333-5555 Strikers İNF (Find primary key, hint: you should have a composite primary key of 2 fields for this example) 150 160 145 170 180 177 ое Jim P. 2NF (A->B) remember B is a nonkey field from INF while A is a field or field(s) from the primary key from INF. r B is a nonkey field from a relation in 2NF while A is a nonkey field from the same relation 3NF (A→B) remembe in 2NF Show transcribed image text Team number (TeamNo) Player number (PlayerNo)an integer that identifies a playe Scorel (Scorel) Score2 (Score2) Score3 (Score3) an integer that identifies a team such as team number 1 is the Strikers r uniquely within the league bowling score of game number 1 such as 167 bowling score of game number 2 bowling score of game number 3 there are 15 weeks in the league. This data item will represent the week number being eek number (WeekNo) played so for the first scheduled meeting it would be recorded as week number 1. Player phone (PhoneNo) Player Name (PlayerName) Player Gender (Gender) Team name (Team Name) Team captain (Captain) Cell phone number of a player. First and last name of player. Gender of player. 1 for male, 2 for female. There are 4 players to a team. Each team will select a team name. Each team selects one player to represent the team captain. Hint: Remember how the supervisor was recorded in the Employees table from the Northwind database Email account of a player Player email (Email) The following is an example of possible data values for most of the data elements described above… Team no. Player No. Name Score Score 2 Score 3 Week No Phone Team Name 222-555 Strikers 1 333-5555 Strikers 1 333-5555 Strikers 150 160 145 170 180 177 150 165 170 60 162 15 oe Sue P Lou M. Donna S 200 80 19 233-8888 Hard Hitters 444-5555 Hard Hitters 2 222-5555 Strikers 2 333-5555 Strikers İNF (Find primary key, hint: you should have a composite primary key of 2 fields for this example) 150 160 145 170 180 177 ое Jim P. 2NF (A->B) remember B is a nonkey field from INF while A is a field or field(s) from the primary key from INF. r B is a nonkey field from a relation in 2NF while A is a nonkey field from the same relation 3NF (A→B) remembe in 2NF
Expert Answer
Answer to Can you this normalize this datebase as it describe at the bottom of page 2? 1NF, 2NF, AND 3NF… . . .
OR
