Monday, March 26, 2012

normalization

hi..

using normalization is good or not?if we don't follow normalization

than what will happen? and if follow than what will happen?

thanx

Hi,

Normalization is nothing but the Efficient organization of data in your database. it makes sure that you dont store the same data in more than one table and also that you only store the related data in a table.

Naturally, if a database is normalized then the space consumed by the database also reduces.The Data consistency within the database will be maintained. But the drawback is that when a database is normalized, it would reduce the performance as data must be obtained from several tables and joined together and Processed. Hence a balance must be striked when implementing Normalization in databases

May be you could go through this article for better understanding

http://searchsecurity.techtarget.com/tip/0,289483,sid87_gci1120129,00.html

SanDoty

No comments:

Post a Comment