Normal Form In DBMS And Types Of NF

Normal Form In DBMS And Types Of Normal Form Explain, Types Of NF In DBMS Explain, What Is NF In DBMS

Basically the normal form of data indicate how much redundancy is in that data.

Types of normal form
1NF
2NF
3NF
                             BCNF (Boyce-Codd Normal Form)
                             4NF
                            5NF (PJNF)
                           DKNF(Domain Key Normal Form)


1NF Keys;  No repeating groups
2NF No partial dependencies
3NF No transitive dependencies
BCNF Determinants are candidate keys
4NF No multivalued dependencies

Tweet