What is normalization and what is BCNF.

General discussion on technical and managerial topics
no avatar
adams369
 
Posts: 13
Joined: Tue Dec 18, 2012 9:30 pm

What is normalization and what is BCNF.

by adams369 » Wed Jan 30, 2013 4:45 pm

Hi frinds.
What is normalization and what is BCNF.
Please give me brief description with simple example.
Please help me.

Thanks & Regards
Adams
Uschemistoncall

no avatar
daniel88
 
Posts: 11
Joined: Thu Dec 27, 2012 12:37 pm
Location: VIET NAM

by daniel88 » Sun Feb 03, 2013 10:40 am

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored. There are several benefits for using Normalization in Database.

Return to General Discussion

cron