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. 
 

Login/Register to Answer

Related Questions