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

What is the dynamic sql in oracle?

599


What is oracle data type?

555


How to create tables for odbc connection testing?

495


Is insert autocommit in oracle?

605


What is oracle latest version?

584






Explain coalesce function?

626


How to write text literals in oracle?

614


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1749


How to convert characters to dates in oracle?

560


Explain oracle left join with an example?

587


Difference between pre-select and pre-query

577


What is oracle in java?

524


How would you change old and new values in an insert, delete and update triggers?

545


What is an oracle user role?

569


Name the three major set of files on disk that compose a database in Oracle?

635