Overview
In this tutorial, we will learn about database normal forms. Normalization has many levels with each successive level providing stronger guarantees about the data modification anomalies being eliminated. There are numerous levels. However, the first levels usually provide adequate normalization.
Database Normal Forms
The process of normalization is used to ensure database integrity. The most common normal forms are as follows:
- 1NF
- 2NF
- 3NF
First Normal Form (1NF)
A table in first normal form contains no complex (non-simple) column types, like repeating groups within rows. If a table is not in INF, it is not normalized.
Second Normal Form(2NF)
A table is in second normal form if it is in 1NF and each column that is not part of a candidate key is not functionally dependent upon only a part of any candidate key.
Third Normal Form(3NF)
A table is in third normal form if it in 2NF and every non-key column depends directly on the primary key and not on some other non-key column.
Each normal form, depends on the previous level and it is best practice to work through each form individually to achieve the best results.
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: