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
What is the dynamic sql in oracle?
What is oracle data type?
How to create tables for odbc connection testing?
Is insert autocommit in oracle?
What is oracle latest version?
Explain coalesce function?
How to write text literals in oracle?
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
How to convert characters to dates in oracle?
Explain oracle left join with an example?
Difference between pre-select and pre-query
What is oracle in java?
How would you change old and new values in an insert, delete and update triggers?
What is an oracle user role?
Name the three major set of files on disk that compose a database in Oracle?