What is normalization ?

Answer Posted / ganesh

Normalization is the process of splitting a table into
smaller units to avoid redundancy and reducing the retrieval
time of a data. Let consider if your table having more than
one million records. Now you want to pick up the name or
data of a particular person in a table. It will take much
time to display the data. To overcome this drawback we user
normalization.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which join condition can be specified using on clause?

702


What is rowid in sql?

675


What does (*) mean in sql?

715


Is there any restriction on the use of union in embedded sql?

880


What is synonyms?

771






Which join is like inner join?

762


what is timestamp in mysql? : Sql dba

742


what is sql in mysql? : Sql dba

817


Can we create foreign key without primary key?

705


how can I make a script that can be bi-language (supports english, german)? : Sql dba

728


What is string join?

746


How is use pl and sql?

734


How do I run a program in pl sql?

699


How many sql are there?

733


what is bcp? When is it used?

769