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
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is execute immediate in oracle?
What is a directory object?
How to use an explicit cursor without open statements?
How a database is related to tablespaces?
How to test null values?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is the maximum number of triggers that can be applied to a single table?
Which environment variables are absolutely critical in order to run the OUI?
How to increment dates by 1 in oracle?
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.
How to change system global area (sga) in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to commit the current transaction in oracle?
What is an external table?