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 molap and its advantage? : sql server analysis services, ssas
How to scale out a federation by Sql statement?
What are the different ways you can create databases in sql server?
What is bit data type? What's the information that can be stored inside a bit column?
Name some of the open source software that you can use in alternative to SSR?
State the difference between union and union all?
Write a query for primary key constraint with identity key word?
What is code near application topology?
What is service broker? : sql server database administration
How to test a dml trigger in ms sql server?
What is difference between foreign key and unique key?
Can you explain about buffer cash and log cache in sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Do you know how to implement service broker?
What function does a database engine serve in the sql server?