What is Normalization ?

Answer Posted / gaurav agrawal

Database normalization is a data design and organization
process applied to data structures based on rules that help
building relational databases. In relational database
design, the process of organizing data to minimize
redundancy is called normalization. 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 via the
defined relationships.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of indexes option in exp command.

767


Does oracle partitioning improve performance?

741


How to create a stored procedure in oracle?

794


How to put more than 1000 values into an oracle in clause?

766


How to update a table row with a record?

776


How to create a new table in your schema?

808


How to write date and time literals in oracle?

738


Explain the use of rows option in exp command.

808


What are the limitations oracle database 10g xe?

761


How to drop a tablespace?

745


How to establish administrator authentication to the server?

768


What is catalog in Oracle?

873


Explain compound trigger in oracle?

765


What is a sub query? Describe its types?

766


how can we store any pdf file in oracle

1853