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 get the definition of a stored procedure back?
what exactly sql injuction.how to overcome.....
How to check parameter value in stored procedure sql server?
How can a user-defined datatype be created?
What is a result set object returned by odbc_exec()?
What is a heap?
What objects does the fn_my_permissions function reports on? : sql server security
What is the need for indexing?
What is the new security features added in sql server 2014? : sql server security
What are a database and a data warehouse?
what is the main function of a query parameter?
what are the different stages of Report Processing?
What’s the use of custom fields in report?
How to delete all rows with truncate table statement in ms sql server?
What is history table in sql server?