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 do we create privileges in oracle?
What are the differences between lov and list item?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Explain the use of full option in exp command.
how to do daily transactions with out sql* loader control file regesterd in apps?
How to use subqueries in the from clause in oracle?
What is java oracle used for?
What are the numeric comparison operations?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to define a cusotmer as a supplier in ORACLE R12
What happens to the current transaction if the session is ended?
What are the attributes that are found in a cursor?
Difference between the “verify” and “feedback” command?
How to assign data of the deleted row to variables?
How to convert characters to numbers in oracle?