Normalization In A DBMS And Its Use

Asked By Edwardo B Patton 0 points N/A Posted on - 03/30/2016

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?

• Status: Open
• Question Views: 368
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Anonymous

Answered By Ella T Herring 15 points N/A #183401

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. 

 

About Ella T Herring

Questions
15

Answers
9

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/30/2016
• Question Category: Anonymous