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

when normalization is required

Answer Posted / shahnaz

Normalization is used to improve the performance of database and is applied in the last step of logical database design.The Goal of Normalization is to
1.Eliminate the duplicate data from table
2.Ensure data dependency

we can achieve this by creating multiple tables for each set and by creating primary and foreign keys and building relationship between the newly created tables.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the working of foreign key?

977


What is attribute indicator in pl sql?

961


Can we rollback delete command?

936


How do you drop a trigger?

924


What is numeric function sql?

988


How many sql are there?

925


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

994


What does where 1 1 mean in sql?

981


Explain dml and ddl?

923


How can we link a sql database to an existing android app?

983


Is truncate ddl or dml?

945


Can we use having without group by in sql?

929


What is the use of procedures?

926


Can we use ddl statements in stored procedure?

1097


What is sql entity?

1031