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

Explain what stored procedure sp_replcounters is used for? : sql server replication

1005


Is ssrs support other database except ms sql server?

96


Why use triggers?

577


Some queries related to SQL

592


What do you understand by mirroring?

570






What is simple indexing method?

577


How to convert binary strings into integers in ms sql server?

559


What is the difference between clustered index and primary key?

508


How can you control the amount of free space in your index pages?

620


What is user-defined multi-statement table-valued function?

659


What is oltp (online transaction processing)?

587


What are date and time data types in ms sql server?

529


What is the difference between deallocate cursor and close cursor?

724


What is indexed view? How to create it?

599


How many types of keys are there?

530