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

 What are the oracle DML commands possible through an update strategy?

1061


How many types of table in Oracle?

1119


How to filter out duplications in the returning rows using oracle?

1015


What is a trigger and what are its types?

1223


What is the scope of a local variable?

1063


Is postgres faster than oracle?

1026


What are the differences between char and varchar2 in oracle?

1167


What is recovery manager in Oracle?

1052


How do I manually create a database in oracle?

1019


Why does oracle 9i treat an empty string as null?

1053


How will you write a query to get a 5th rank student from a table student_report?

1861


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3049


How will you differentiate between varchar & varchar2?

1041


State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030


what is normalisation?what are its uses?

2270