What are the different types of the Normalizations Forms (NF). What are their important roles in the Normalization of the database in Relational Database Management System (RDBMS)?Database Normalization is such a nice and formal way to decompose the tables in the in Relational Database Management System (RDBMS) into the small tables to reduce or minimize the Redundancy and Anomalies to insert, update and delete the records in our database. It helps us to create the functional dependencies like Primary Key and Candidate Key for formal relations in the tables. At the starting time in the relational database three main and important forms of the normalization were introduced and utilized by the database management. These forms were well known by First Form (1NF), Second Form (2NF) and Third Form (3NF) of the Database Normalization in the formal and relational manners. Third Form (3NF) is also known as Boyce- Codd normal form after the names of the experts who created this form of normalization. These experts were R.Boyce and E.F.Codd. They defined the BCNF in the simple way to understand and implement the relations between the table and columns from the other tables. Only first form of normalization is not functional dependent but all the others are totally functional dependency among the attributes of the tables. Later on we start using the higher level than the BCNF which are quite rare in use in our Relational Database Management System (RDBMS).

Here are more details on the different types of the forms of the normalization:-
1) First Form of Normalization (1NF) is defined to have one and only one value of the intersection of each row and each column in the table. It is the basic step of the normalization process to minimize the duplicate values form the tables.
2) Second Form of Normalization (2NF) if the normalized form is overwriting the 1NF and there is no partial dependency on the attributes in the tables. Every other attribute are totally dependent on the primary key.
3) Third Form of Normalization (3NF) is defined as the form in which 1NF and 2NF is overwrite to reduce the all transitively dependent attributes are totally dependent on the Primary key. The dependent keys are also called the Candidate Key. BCNF is really close or similar to the 3NF but some where the dependency remains in the same table. In the 3NF is used in database design to reduce the dependencies and anomalies in the tables.
4) Fourth Form of Normalization (4NF) is the higher normal form than the BCNF which reduces the Non-Trivial Multiple dependencies and redundancies from the tables.
5) Fifth Form of Normalization (5NF) is also known as Project-Join Normal Form (PJNF) which describe there is no join dependency in the table. This form of normalization is rarely used in the database.

It is very important to have the normalization in the database up to some extent to reduce the redundant data and duplicities from the table to have the controls on the anomalies to insert, update and delete records without any confusion and difficulties. If we are handling the anomalies for three different types like insert anomalies, update anomalies and delete anomalies, then we are good to go for the better performance and usability.

If you are beginner to the database management system, then it is must to know about these Normalization Forms. It will be good for us to learn more about these terminologies to design a database. I know after start reading the information on these forms you will become the best designer for your companies and organization. lets discuss it in more detail in the next articles.

Thanks,
Sandeep Rajmail