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
How to delete an existing row from a table in oracle?
In oracle there is column command, how will you explain that?
what is the use of system.effective.date variable in oracle?
How to get maxsal , minsal, ename department wise in single query
how the indexes are stored in the Oracle Database?
Hi Can any one tell me what are the API's used in requisition import.
What happens in oracle commit?
Explain what are the uses of rollback segment?
Difference between varchar and varchar2 data types?
How to create a server parameter file?
What is flashback in Oracle?
What is Redo Log Buffer in Oracle?
How to specify default values in insert statement using oracle?
What are the original export and import utilities?
List out the components of logical database structure of oracle database.