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

Explain cascading triggers.

574


What is bulk copy or bcp in oracle?

610


What is coalesce function?

575


How to convert a date to char in oracle? Give one example.

589


How to shutdown your 10g xe server from command line?

556






Define oracle database

596


What is a system tablespace and when it is created?

560


What are privileges and grants?

572


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

578


How to convert csv to table in oracle?

528


How to use select statement to count the number of rows in oracle?

557


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

524


How to use windows user to connect to the server?

534


What happens if you set the sga too low in oracle?

556


How to define and use table alias names in oracle?

509