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 are the purpose of Normalisation?
Would you store your query in a ssrs report or a database server? State the reason why?
What are the differences between sql server and mysql.
How to execute the cursor queries with "open" statements?
Where cross join is used?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
How to remove duplicate rows from table except one?
What are sql server functions?
What are the advantages of using a stored procedure?
Explain transaction server isolation?
Define the one-to-one relationship while designing tables.
What is indexed view? How to create it?
What is the difference between lock, block and deadlock? : sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Which language rdl files made of?