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
Can binary strings be converted into numeric or float data types?
How to sort query output in descending order in ms sql server?
How do you improve the performance of a SQL Azure Database?
What is Sqlpaging in SqlServer 2005 ?
How do I save a stored procedure in sql server?
How to use old values to define new values in update statements in ms sql server?
How to use subqueries in the from clause in ms sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What the different components in replication and what is their use?
State a few properties of relational databases?
What is the most common type of join?
How to test a dml trigger in ms sql server?
What is use of except clause? How it differs from not in clause?
Difference between report and query parameter.
What is named query? : sql server analysis services, ssas