What is Normalization ?

Answer Posted / sachin

Normalization is a method of break down complex table’s
structure into simple table structure by using certain
rules. Normalization usually involves dividing a database
into two or more tables and defining relationships between
the tables. The objective of Normalization 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. With the help of this method we can reduce
redundancy in a table and remove the problems of
inconsistency and reduce the amount of space.

see more info on this link

http://www.mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What%20is%20Normalization?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

601


Explain the use of inctype option in exp command.

604


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1774


How to rename an index in oracle?

628


How to select all columns of all rows from a table in oracle?

597






Why do you use stored procedures and state some of its disadvantages?

578


Can group functions be used in the order by clause in oracle?

594


Explain the use of consistent option in exp command.

564


What is a user role in oracle?

631


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

664


How can we create the complete backup of data in the oracle.

1699


why dont we assign not null constraint as table level constraint.

2263


Explain the use of control file?

666


Why does oracle 9i treat an empty string as null?

548


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1818