what is normalization?
what is denormalization?
- 9 Answers
- 33232 Views
- Satyam, I also Faced
- E-Mail Answers
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
Explain syntax for disabling triggers?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What are ddl triggers and types of ddl trigger?
What are horizontal and vertical scaling?
Explain contrast amongst grouped and non-bunched records?
Explain about nested stored procedure?
What is the definition for sql server 2000?
What is set nocount on?
how to trace the traffic hitting a sql server? : Sql server database administration
What is the difference between value type and reference type?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Explain acid?
What are the kinds of subquery?
What are the essential components of sql server service broker?
Is it possible to replicate data from sql server to oracle? : sql server replication
