what is normalization?
what is denormalization?
Answer Posted / abdul quadir parihar
Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How to list all user defined functions in the current database?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What is the ‘fillfactor’?
What is mssql?
What is the difference between a clustered index and a non-clustered index?
What is transact-sql ddl trigger?
Is BCNF better than 2NF & 3NF? Why?
What is transaction server explicit transaction?
How can we solve concurrency problems?
What is database white box testing?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is a natural primary key?
What is sql profiler. What are the default templates with it? : sql server database administration