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

Explain the use of consistent option in exp command.

564


What is a trigger oracle?

575


what is IDE,DMV in sql server?

2264


How to view all columns in an existing table?

558


How to insert a record into a table?

654






How to list all tables in your schema?

627


What is the data pump export utility?

661


What is a tns service name?

550


how to make an oracle object

1872


What is the use of aggregate functions in oracle?

593


What are advantages of dateset in datastage?

1764


How to use in conditions in oracle?

571


candidate key is subset of super key but not vice-verse explain

1588


How do I use os authentication with weblogic jdriver for oracle and connection pools?

589


What is difference between truncate and delete?

573