What is database normalization?

Answer Posted / anirudh

Normalization is breaking the database into different
tables and defining a relationship between them.
Objective is to isolate the data so that additions and
deletions can be made in one table and propagated to other
tables through relationships.

Is This Answer Correct ?    20 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List all types of constraints in sql server?

522


What are 3 ways to get a count of the number of records in a table?

621


What is the difference between for xml raw and for xml auto?

579


what is nonclustered index

557


What are different type of Collation Sensitivity?

565






Is t sql the same as sql server?

524


What do you understand by replication in sql server?

593


Define cross join in sql server joins?

599


Can we insert data if clustered index is disabled?

517


Explain syntax for disabling triggers?

528


What does the not null constraint do?

589


Tell me the phases a transaction has to undergo?

558


What are “phantom rows”?

1253


What is update locks?

518


How to filter records of table in SQL SERVER?

609