Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is normalization?
what is denormalization?

Answer Posted / abdul quadir parihar

Normalization is the process of decomposition of complex
data in to simple way.

Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the operating modes in which database mirroring runs?

1025


Determine when an index is appropriate?

1016


How to grant a permission in ms sql server using "grant execute" statements?

1025


How to download microsoft sql server 2005 express edition?

975


What is Sqlpaging in SqlServer 2005 ?

1013


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

858


What are key constraints?

927


Can you leave a union at any time?

999


Can a synonym name of a table be used instead of a table name in a select statement?

973


What are commonly used mssql functions in php?

999


What is filter index?

908


How to select an exiting database using mssql_select_db()?

910


What is clr ddl trigger?

911


Tell me what is de-normalization and what are some of the examples of it?

958


Detail about the hardware which is supported by SQL server?

1009