what is normalization?
what is denormalization?

Answer Posted / shantanub

Normalization is the process of organizing data in a
database. This includes creating tables and establishing
relationships between those tables according to rules
designed both to protect the data and to make the database
more flexible by eliminating two factors: redundancy and
inconsistent dependency.

Is This Answer Correct ?    51 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain filestream storage of sql server 2008?

694


What is exporting and importing utility?

774


Determine how to use the inserted and deleted pseudo tables?

725


what are the Prerequisites for Replication?

10875


What is the use of toad or sqldbx.?

885






What is Replication?

808


How to test subquery results with the exists operator?

745


How to modify existing triggers using "alter trigger"?

701


Does sql server use t sql?

724


How to how to convert numeric expression data types using the convert() function??

722


explain databases and sql server databases architecture? : Sql server database administration

699


Give a example to search fr a string in all stored procedure in sql server.

698


What is merge join?

808


How to create a view with data from multiple tables?

767


What is merge replication?

861