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 a checkpoint?

544


What is "scheduled jobs" or "scheduled tasks"?

566


Explain what is “asynchronous” communication in sql server service broker?

507


Explain throw statement in sql server 2008?

585


How do you send email on SQL Server?

592






Does a specific recovery model need to be used for a replicated database? : sql server replication

540


How we can compare two database data?

527


What are four major operators that can be used to combine conditions on a where clause?

605


How to change the password of a login name in ms sql server?

570


How to modify an existing user defined function?

612


What are tables in sql server?

547


How to get the definition of a stored procedure back?

534


what is the difference between a primary key and a unique key? : Sql server database administration

535


What is right outer join in sql server joins?

700


What is etl - extraction, transformation, and loading?

526