what is normalization?
what is denormalization?
Answer Posted / koti
In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.
De-normalization is introducing redundancy.
| Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What is the maximum row of a size?
What different steps will a sql server developer take to secure sql server?
What is nolock hint in sql server 2008
How much does sql server 2016 cost?
Do you know the capabilities of cursors?
Why we use trigger in sql server with example?
What is history table in sql server?
Tell me what is the order in which the sql query is executed?
What is difference between cte and view?
What is subreport?
What are scalar functions in sql?
What is a cube? : sql server analysis services, ssas
Explain a join?
What is attribute? : sql server analysis services, ssas
What are the mathematical functions supported by sql server 2005?