Database Normalization - Second Normal Form (2NF)

The second normal form ensures each attribute describes the entity

  • Create separate tables for sets of values that apply to multiple records
  • Relate these tables with a foreign key

Records should not depend on anything other than a table’s primary key, including a compound key if necessary.