In a DBMS, usually normalization is done for a relational database. What is this Normalization procedure? What is its purpose? What are the different normalization types?
Normalization In A DBMS And Its Use
Normalization of the process of bringing the database in a normal form without any nested relations, multivalued attributes, transitive relations, redundant data, non-atomic values, etc.
The types of normalization are as follows:Â
• FIRST NORMAL FORM
• SECOND NORMAL FORM
• THIRD NORMAL FORM
• BOYCE-CODD NORMAL FORM
• FOURTH NORMAL FORM
All these normal forms eliminate minimum on one of the anomalies from the database and provide a more efficient and less complex database.Â
Â