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 / koti

In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.

De-normalization is introducing redundancy.

Is This Answer Correct ?    12 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is molap and its advantage? : sql server analysis services, ssas

965


How to scale out a federation by Sql statement?

116


What are the different ways you can create databases in sql server?

1079


What is bit data type? What's the information that can be stored inside a bit column?

902


Name some of the open source software that you can use in alternative to SSR?

159


State the difference between union and union all?

915


Write a query for primary key constraint with identity key word?

1011


What is code near application topology?

279


What is service broker? : sql server database administration

973


How to test a dml trigger in ms sql server?

1023


What is difference between foreign key and unique key?

994


Can you explain about buffer cash and log cache in sql server?

931


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1000


Do you know how to implement service broker?

913


What function does a database engine serve in the sql server?

1018