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 ssrs maintain security?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is subquery in sql?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
what is the difference between count(*) and count(1) ?
What is database isolation in sql server? : sql server database administration
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Explain the advantages of merge replication?
What is openrowset sql server?
Does a server store data?
Explain what are sparse columns?
How check triggers in sql server?
What is ssrs?
What is the difference between a function and a stored procedure?
How you can change the database name in SQL SERVER?