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
What is a field in a table?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Can a unique index be created on a column, which contains null?
Would you store your query in a ssrs report or a database server? State the reason why?
What are the types of database recovery models?
Explain log shipping and mention its advantages.
What do you know about system database? : SQL Server Architecture
What is hot add cpu in sql server 2008?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
How do I clean up sql server transaction log?
What are the different SQL Server Versions you have worked on?
How to convert character strings into numeric values?
explain extended properties
Explain Geometry datatype in sql server 2008 with example
What is the command used to check locks in microsoft sql server?