ERD Normalization Test

[AkiraDotA]

• Identify what NF you think each table is in.

  • 'Gods' Table: 3NF
  • 'Gods_Selected' Table: 3NF
  • 'Teams' Table: 3NF
  • 'Players' Table: 3NF
  • 'Records' Table: 3NF
  • 'Merchandise' Table: 3NF
  • 'Games' Table: 3NF
  • 'Tournaments' Table: 3NF
  • 'Location' Table: 3NF
  • 'Twitch_Team' Table: 3NF
  • 'Employees' Table: 3NF

• Are there any attributes that should be in a different table in their design?

  • In the 'Gods' table, I suggest moving the 'First_Ability', 'Second_Ability', 'Third_Ability', and 'Ultimate' into an 'Ability' table. Then, to make the proper 1:M relationship with 'God', you would want to make a join table, possibly called 'God_Ability', that contains the PK from 'Gods' and 'Ability'.

• Do they have any partial dependencies?

  • Matt does not have any partial dependencies,

• Do they have any transitive dependencies?

  • Matt does not have any transitive dependencies.