Hi, I made 3nf final sats of table but I don't know how to elimanate duplicates groups.I know Players_Number and Goal is repeating, i am not sure


please check my table

here is my 3nf solution:

3NF:

Player_Team_game(Game_Code(PK),Team_Id(PK FK),Players_Number(PK),Goal,Assists)

Team(Team_Id(PK),Team_Name)

Penalty(Penalty_Id(PK),Team_Id(FK),Players_Number( FK),Penalty_Minutes)

Game_Statistics(Game_Id(PK FK), Team_Id(PK FK),Players_Number(pK FK),Penalty(PK FK)).


thanks

Attached Files

view.doc (55.5 KB, 5 views)