Advertisements

What is normalization and what is BCNF.

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

Offline
adams369
Posts: 13
Joined: Tue Dec 18, 2012 9:30 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

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

Offline
daniel88
Posts: 11
Joined: Thu Dec 27, 2012 12:37 pm
Location: VIET NAM
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.