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...

Normalization and denormalization

Answer Posted / pragyan

database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.

de-normalization is the process of attempting to optimize the performance of a database by adding redundant data..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain different types of joins?

984


What is policy based management (pbm)? : sql server database administration

1027


How do use Having,Group by,Group function in SQL?

1785


What happens if null values are involved in string operations?

1026


What does normalization do to data?

1136


What is dimension table? : sql server analysis services, ssas

1061


Does hive support indexing?

997


what is difference between NULL and ISNULL in SQL Server 2008?

1055


Can group functions be used in the order by clause in ms sql server?

1064


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1006


What is indexed view? How to create it?

1061


What are two difference between sql azure and azure tables?

161


How to add code to the existing article (using improve article)?

1162


What factors you will consider calculating the storage requirement for that view?

987


What is a result set object returned by mssql_query()?

1223