Interested to Buy Any Domain ? << Click Here >> for more details...
What is Normalization ?
- 55 Answers
- 87979 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
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 are nested tables?
Can we connect to ORACLE db using Windows Authentication?
What are the different types of partitions in oracle?
What is raw datatype in oracle?
What is an oracle database?
How remove data files before opening a database?
How to use subqueries with the in operator using oracle?
How can you use check constraints for self referential integrity?
Is there a combination of "like" and "in" in sql?
What is oracle rownum?
How to assign a tablespace to a users in oracle?
What operating systems are supported by oracle database 10g xe?
How does one get the view definition of fixed views/tables?
What privilege is needed for a user to delete rows from tables in another schema?
What is the best way to do multi-row insert in oracle?
