What is Normalization ?
Answer Posted / rajaram gupta
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is flashback in Oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How oracle handles dead locks?
How to turn on or off recycle bin for the session?
What is data type in oracle?
In which language oracle has been developed?
What is a connect identifier?
How to delete an existing row from a table in oracle?
what is insert all statement in sql
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How many data types are supported?
Explain constraining triggers.
Briefly explain what is literal? Give an example where it can be used?
How to use in conditions in oracle?
How to connect ms access to oracle servers?