What is normalization and how are use normalization in database table?

What is normalization and how are use normalization in database table?

The process of effectively organizing data in a database is called Normalization. It has 2 goals: eliminating or removing unnecessary data, and guaranteeing data dependencies make sense. Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

The database community has developed a series of guidelines for ensuring that databases are normalized. These guidelines are called normal forms and are numbered from 1 to 5. The first is the lowest form of normalization and is referred to as first normal form or 1NF. The highest is 5 and referred to as fifth normal form or 5NF. In practical applications, you'll often see 1NF, 2NF, and 3NF along with the occasional 4NF. The fifth normal form is very rarely seen. For more information about this, you may visit Database Normalization Basics.