Monday, February 11, 2019

Database Normalization - 1NF, 2NF, 3NF and 4NF




1st Normal Form
---------------
Each Cell to be Single Valued
Entries in a column are same type
Rows uniquely identified - Add unique id

2nd Normal Form
---------------
All attributes (non-key columns) depened on the key

3rd Normal Form
---------------
All Fields(Column) can be determind only by the key in the table and no other column

4th Normal Form
---------------
No Multi-Valued Dependencies

No comments:

Post a Comment

It's OK to be NOT-OK.

02/22/2021  Last week I was just un-productive and was not doing enough to talk about. I also wanted to say that weeks before the last, I ha...