Database normalizationby joseph

29Sep

Normalization is the process of efficiently organizing data in a database or it is the representation of logical data in a computer representable form.The different types of normalizations are First normal form(1NF),Second normal form(2NF),Third normal form(3NF),Boyce-Codd normal form(BCNF),Fourth normal form(4NF) and Fifth normal form(5NF).

In this figure shows the unnormalized form of database .Here we can see the data repeating which is undesirable in good database design.Update ,delete are very difficult in this design.

First Normal Norm(1NF)

The first normal form (or 1NF) requires that the values in each column of a table are atomic. By atomic we mean that there are no sets of values within a column.

Read the rest of this entry »

Tags: 3.5NF, BCNF, Database normalization, fifth normal form, first normal form, fourth normal form, second normal form, third normal form
Posted in Database | 2 Comments »