what is normalization?
what is denormalization?

Answer Posted / sarika desai

Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tables in sql?

794


What are magic tables in sql server?

795


Which is the main third-party tool used in sql server?

672


How to backup SQL Server Reporting Services ?

122


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

724


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

701


What are the dis_advantages of stored procedures, triggers, indexes?

1935


What is pessimistic concurrency?

716


How to recompile stored procedure at run time?

735


What is difference between inner join and full join?

773


Do you know the isolation level that sql server support?

712


How to create a local temporary stored procedure?

698


What command is used to delete a table from the database in the sql server and how?

751


What is the main difference between ‘between’ and ‘in’ condition operators?

802


What is sql sandbox in sql server?

835