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

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

how to insert the records in particular position

1 Answers  

what are the type of locks ? : Sql dba

0 Answers  

What are the different types of tables in sql?

0 Answers  

What are local and global Indexes and where they are useful.

0 Answers  

What are expressions?

0 Answers  

What is the basic form of sql query?

0 Answers  

What is sap sql?

0 Answers  

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

Which table is left in left join?

0 Answers  

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

What are the benefits of triggers?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories