Site icon XtraCode.me

MySQL Normalization

Database normalization is a process of organizing fields and tables which reduces dependancy of data and redundancy.

There are 6 normal form. In most cases it’s only need 3 normal form to achieve normalization.

What normal forms are?

1NF (First Normal Form) Rules

2NF (Second Normal Form) Rules

3NF (Third Normal Form) Rules

Offcourse, there are pros and cons of using normalization.

Advantages of normalizing database are:

Disantavtages:

Exit mobile version