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
Explain the use of consistent option in exp command.
What is a trigger oracle?
what is IDE,DMV in sql server?
How to view all columns in an existing table?
How to insert a record into a table?
How to list all tables in your schema?
What is the data pump export utility?
What is a tns service name?
how to make an oracle object
What is the use of aggregate functions in oracle?
What are advantages of dateset in datastage?
How to use in conditions in oracle?
candidate key is subset of super key but not vice-verse explain
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is difference between truncate and delete?