pj_mcahbti

 Profile Answers by pj_mcahbti 

• Mar 21st, 2006

 

NORMALIZATION is used for the process of breaking up the data into several tables,so as to minimize the number of times we have to repeat the same data.

it consists of several steps to systematically increase internal consistency,minimal redundancy,and maximum stability in the data model....

there are five normal forms......boyce and codd proposed a stronger definition of third normal form...i.e. BCNF.

 subsequently,Fagin defined fourth and fifth normal form........

Kaviya

• Feb 20th, 2015

 

Normalized tables are usually smaller and have a smaller foot-print because the data is divided vertically among many tables. This allows them to perform better as they are small enough to get fit into the buffer.