Normalization In A DBMS And Its Use

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 15 points N/A #183401

Normalization In A DBMS And Its Use

qa-featured
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. 
 

Related Questions