Interview Questions   Tutorials   Discussions   Programs   

DB2 - What is Normalization in DB2 ? first normal form, second normal form explain?

asked mar August 20, 2014 11:50 AM  

What is Normalization in DB2 ? first normal form, second normal form explain?


1 Answers

answered By Mswami   0  
Normalization of Database:

Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables.

Normalization is used for mainly two purpose:
• Eliminating redundant(useless) data.
• Ensuring data dependencies make sense i.e data is logically stored.

Normalization Rules:

Normalization rules are divided into following normal form.
1.First Normal Form
2.Second Normal Form
3.Third Normal Form

First Normal Form (1NF):

As per First Normal Form, no two Rows of data must contain repeating group of information i.e each set of column must have a unique value, such that multiple columns cannot be used to fetch the same row. Each table should be organized into rows, and each row should have a primary key that distinguishes it as unique.
The Primary key is usually a single column, but sometimes more than one column can be combined to create a single primary key.

Second Normal Form (2NF):

As per the Second Normal Form there must not be any partial dependency of any column on primary key. It means that for a table that has concatenated primary key, each column in the table that is not part of the primary key must depend upon the entire concatenated key for its existence. If any column depends only on one part of the concatenated key, then the table fails Second normal form.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!