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 new changes are being made in SQL Server?

1258


what protocol both networks use? : Sql server database administration

1014


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

935


Can I delete event logs?

974


What is the purpose of a table?

993


Explain optimistic and pessimistic concurrency?

1029


What are parameterized reports?

204


What are cursors stored procedures and triggers?

1076


What is the web service used for reporting services?

126


What is the difference between Normalization and De-normalization?

1138


Define tempdb database?

1037


Which command is used for user defined error messages?

1101


Can you import Microsoft Excel data to SSRS?

135


How do users use Report Builder with SQL Server data sources?

164


What is the difference between getdate and sysdatetime?

1059