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

What is a clob in sql?

569


How many sql commands are there?

675


What are the types of records?

535


what are the different tables present in mysql? : Sql dba

504


What is difference between stored procedures and application procedures?

572






What is percent sign in sql?

719


What is query optimization in sql?

550


How to call shell script from pl sql procedure?

625


How many types of triggers are there in pl sql?

574


Can ddl statements be used in pl/sql?

594


What are instead of triggers?

626


What are the different schemas objects that can be created using pl/sql?

528


What does sign mean sql?

573


Is pl sql and postgresql same?

573


What do you mean by field in sql?

536