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 difference between my sql and sql?

539


What is dynamic query?

545


what is an alias command? : Sql dba

554


How can you tell the difference between an index and a view?

502


What is use of term?

630






Can there be 2 primary keys in a table?

565


what is a constraint? Tell me about its various levels. : Sql dba

568


Can you upgrade sql express to full sql?

525


What does (+) mean in sql joins?

532


How to rename a column in the output of sql query?

543


What are the limitations of sql express?

535


Can we join 3 tables in sql?

504


Explain how can you save or place your msg in a table?

601


What is t sql in sql server?

574


How do I run a sql trace?

534