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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

when normalization is required

Question Posted / rashmi

Answers were Sorted based on User's Feedback



when normalization is required..

Answer / 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

when normalization is required..

Answer / dhivya

when large amount of data required in database we need to find important data.
In normalization there will be important primary keys that must merge together so that we kind find the relations of the keys.
Eg. trans Id,video,cust ID
cust ID be the primary key in customer table
eg. cust ID, name, address, phone no, mail id 

Is This Answer Correct ?    2 Yes 0 No

when normalization is required..

Answer / rizwana

To decompose a large relation into two or more relations then we can use normalization

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

What is foreign key and example?

0 Answers  

How to pipe multiline string to isql?

0 Answers  

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

What is #table in sql?

0 Answers  

What is delete command in sql?

0 Answers  

How do I run a script in sql developer?

0 Answers  

What are the advantages of VIEW?

5 Answers  

How many types of normalization are there?

0 Answers  

What is the source code of a program?

0 Answers  

How many levels can subqueries be nested in a FROM clause?

7 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories