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

How sql query is executed?

1182


what is the difference between union and union all? : Sql dba

1060


How do I use google cloud in sql?

1143


What is trigger in sql? Explain

1036


Can we insert data into view?

947


What are the different types of sql commands?

1174


Define sql delete statement.

1061


How do you exit in sql?

1155


What is the difference between a procedure and a function?

1206


What are pl/sql cursor exceptions?

1158


What is spool?

1104


What are basic techniques of indexing?

1439


Can a table have no primary key?

1108


Cite the differences between execution of triggers and stored procedures?

1135


Is natural join same as inner join?

981