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...

Define Normalization with example?

Answer Posted / babu vincent

Normalization:
normalization is used to reduce the repetition..
for example if a table contains a column repeating same datatype and for same purpose..
look at simple example a item purchased of a customer may contain many which also include separate prices so instead of creating repeated column for each item and price.. one table is created with one column for item name and one for column name.. then relationship(one to many) can be created and records in item table can be connected with cstomer table which includes order no as primary key..

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create database in oracle using command line ?

1039


What do you mean by group by clause?

993


How a tablespace is related to data files?

1072


What is the dynamic sql in oracle?

1025


State the difference between a primary key and foreign key?

896


What is the order of defining local variables and sub procedures/functions?

1018


What is MTTR advisor in Oracle?

1048


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2584


What is archive log in Oracle?

1082


How to write an inner join with the where clause in oracle?

1016


Write a syntax for update query in oracle?

982


How to assign values to variables?

1059


Explain self joins in oracle?

957


What happens if you set the sga too low in oracle?

1073


What is rowid and rownum in oracle?

964