Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How do we create privileges in oracle?

1046


What are the differences between lov and list item?

1065


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.

5329


Explain the use of full option in exp command.

1116


how to do daily transactions with out sql* loader control file regesterd in apps?

1687


How to use subqueries in the from clause in oracle?

1112


What is java oracle used for?

1021


What are the numeric comparison operations?

1111


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1146


How to define a cusotmer as a supplier in ORACLE R12

2230


What happens to the current transaction if the session is ended?

1098


What are the attributes that are found in a cursor?

1076


Difference between the “verify” and “feedback” command?

1363


How to assign data of the deleted row to variables?

1075


How to convert characters to numbers in oracle?

1065