Normal Forms

1st Normal Form

  • Each cell should be single valued
  • Entries in a column are of same type
  • Rows are uniquely identified - Add unique identifier or Add more columns to make unique

2nd Normal Form

  • All attributes (Non Key columns) should be dependent on the key

3rd Normal Form

  • All fields (columns) can be determined only by the key in the table and no other column

4th Normal Form

  • No multi-valued dependencies

results matching ""

    No results matching ""