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 is a field in a table?

1068


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2268


Can a unique index be created on a column, which contains null?

966


Would you store your query in a ssrs report or a database server? State the reason why?

155


What are the types of database recovery models?

1181


Explain log shipping and mention its advantages.

1083


What do you know about system database? : SQL Server Architecture

1031


What is hot add cpu in sql server 2008?

977


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1045


How do I clean up sql server transaction log?

1117


What are the different SQL Server Versions you have worked on?

1055


How to convert character strings into numeric values?

1144


explain extended properties

1034


Explain Geometry datatype in sql server 2008 with example

1045


What is the command used to check locks in microsoft sql server?

1091