What is use of Normalization?explain all the form of Normalization?

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions