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 is a data lock in oracle?
How to write date and time literals in oracle?
How to best split csv strings in oracle 9i?
What are nested tables?
How to establish administrator authentication to the server?
How do I uninstall oracle client from windows?
Why is oracle database so popular?
What are the different types of modules in oracle forms?
What is PL/SQL ?
How to run create database statement?
Explain the use of tables option in exp command.
Can you tell me how to add new column in existing views?how?How is possible?
How remove data files before opening a database?
What is the order of defining local variables and sub procedures/functions?
How can we view last record added to a table?