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 dynamic SGA and static SGA
How do we get field detail of a table?
What is an oracle user account?
How to lock and unlock a user account in oracle?
List the various oracle database objects?
What is execute immediate in oracle?
How to loop through a cursor variable?
List out the components of logical database structure of oracle database.
Explain the use of consistent option in exp command.
What is truncate oracle?
How to convert characters to dates in oracle?
How to establish administrator authentication to the server?
What does sharding mean?
What is format trigger?
what is the difference between functional dependecy and multilevel dependency?