What is Normalization ?

Answer Posted / ravi kumar

Normalization is the relational database design technique
in which most ambiguity is removed.

Normalization usually involves dividing a database into two
or more tables and defining relationships between the
tables. The objective is to isolate data so that additions,
deletions, and modifications of a field can be made in just
one table and then propagated through the rest of the
database though the defined relationships.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sub query? What are its various types?

592


How view is different from a table?

585


What is a proxy object?

594


What are the advantages of oracle?

564


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1468






How to divide query output into groups in oracle?

569


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1270


How to write an inner join with the where clause in oracle?

601


Explain the function of optimizer in oracle?

614


What is data block in Oracle?

634


What privilege is needed for a user to create indexes in oracle?

588


What is a oracle database?

627


What is the quickest way to export a table to a flat file?

583


What is a snapshot in oracle database?

593


Differentiate between post-database commit and post-form commit?

557