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

How can sql injection be stopped? : sql server security

973


How to provide default values to stored procedure parameters?

1019


In case you have filters in your report, when filters will be applied in cached report instance?

106


Can sql server be linked with other servers like oracle?

918


Explain throw statement in sql server 2008?

948


What are the differences between web role and worker role?

122


What are functions in the sql server?

1149


What are cursors in ms sql server?

1128


How you can get the list of largest tables in a database?

950


What are views used for?

981


What is normalization and what are the advantages of it?

935


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

936


How do I delete a sql server database?

1001


Do you know hot add cpu in sql server 2008?

907


How to execute a stored procedure in ms sql server?

1093