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
How to write an inner join with the where clause in oracle?
Explain the use of inctype option in exp command.
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.
How to rename an index in oracle?
How to select all columns of all rows from a table in oracle?
Why do you use stored procedures and state some of its disadvantages?
Can group functions be used in the order by clause in oracle?
Explain the use of consistent option in exp command.
What is a user role in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How can we create the complete backup of data in the oracle.
why dont we assign not null constraint as table level constraint.
Explain the use of control file?
Why does oracle 9i treat an empty string as null?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?