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 trigger in sql?

642


What are some predefined exceptions in pl/sql?

555


what are the difference between clustered and a non-clustered index? : Sql dba

531


Why plvtab is considered as the easiest way to access the pl/sql table?

626


When do we use triggers?

592






What is the command used to fetch the first 5 characters of a string?

714


explain the advantages and disadvantages of stored procedure? : Sql dba

536


what are the advantages and disadvantages of views in a database? : Sql dba

537


How do you modify a column in sql?

541


What are inner and outer joins examples of both?

501


What is the purpose of design view?

531


What is a sql trace file?

552


What is sql engine in oracle?

526


Give the order of sql select?

616


Difference between table function and pipelined function?

592