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 are the purpose of Normalisation?

1053


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

153


What are the differences between sql server and mysql.

1101


How to execute the cursor queries with "open" statements?

1185


Where cross join is used?

969


What is the minimum recommended amount of ram for sql server 2012 enterprise?

936


How to remove duplicate rows from table except one?

1015


What are sql server functions?

990


What are the advantages of using a stored procedure?

1009


Explain transaction server isolation?

1050


Define the one-to-one relationship while designing tables.

908


What is indexed view? How to create it?

1020


What is the difference between lock, block and deadlock? : sql server database administration

1055


What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1140


Which language rdl files made of?

131