What is Normalization ?
Answer Posted / lakshmi
Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.
For example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.
| Is This Answer Correct ? | 169 Yes | 26 No |
Post New Answer View All Answers
 What are the oracle DML commands possible through an update strategy?
How many types of table in Oracle?
How to filter out duplications in the returning rows using oracle?
What is a trigger and what are its types?
What is the scope of a local variable?
Is postgres faster than oracle?
What are the differences between char and varchar2 in oracle?
What is recovery manager in Oracle?
How do I manually create a database in oracle?
Why does oracle 9i treat an empty string as null?
How will you write a query to get a 5th rank student from a table student_report?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How will you differentiate between varchar & varchar2?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
what is normalisation?what are its uses?