What is Normalization ?
- 55 Answers
- 78892 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
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 private synonym?
What are the limitations oracle database 10g xe?
How to create a new view in oracle?
What is sequence?
Explain oracle’s system global area (sga).
When system tablespace is created?
Why should I use oracle database?
What is a subquery?
Explain the use of file 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.
Explain the use of online redo log files in oracle.
How to use group functions in the select clause using oracle?
What are the uses of synonyms?
What do you mean by a tablespace?
What are the execution control statements?
