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 I manually create a database in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What privilege is needed for a user to connect to oracle server?
What is the Tune Query
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Describe varray?
what is the scenario where you take the database to NoArchivelog mode?
How to bring a tablespace online?
What is dynamic proxy?
How to convert a string to a date in oracle database?
What is recycle bin in Oracle?
How to call a stored function with parameters?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to start your 10g xe server?
Who developed oracle & when?