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

Can binary strings be converted into numeric or float data types?

1098


How to sort query output in descending order in ms sql server?

985


How do you improve the performance of a SQL Azure Database?

137


What is Sqlpaging in SqlServer 2005 ?

1115


How do I save a stored procedure in sql server?

1052


How to use old values to define new values in update statements in ms sql server?

1331


How to use subqueries in the from clause in ms sql server?

1211


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1079


What the different components in replication and what is their use?

998


State a few properties of relational databases?

1181


What is the most common type of join?

1040


How to test a dml trigger in ms sql server?

1116


What is use of except clause? How it differs from not in clause?

1063


Difference between report and query parameter.

1144


What is named query? : sql server analysis services, ssas

1005