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 new changes are being made in SQL Server?
what protocol both networks use? : Sql server database administration
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Can I delete event logs?
What is the purpose of a table?
Explain optimistic and pessimistic concurrency?
What are parameterized reports?
What are cursors stored procedures and triggers?
What is the web service used for reporting services?
What is the difference between Normalization and De-normalization?
Define tempdb database?
Which command is used for user defined error messages?
Can you import Microsoft Excel data to SSRS?
How do users use Report Builder with SQL Server data sources?
What is the difference between getdate and sysdatetime?