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


Explain Normalization concept?

Answers were Sorted based on User's Feedback



Explain Normalization concept?..

Answer / prasadhari_m@yahoo.com

Noramalization is process of desinnig the datamodel to
effentionley store the data in a database. to reduce the
redundancey.
1st normal form : Elimanate repating groups in individual
tables
Create separate table for ecah set of related data
Identify each set of related data with a primary key.
2nd normal form : Create separate tables for sets of values
that apply to multiply records
->relate these tables with a forgien key
3rd normal form : Elimanate fields that do not depend on
the key

Is This Answer Correct ?    29 Yes 2 No

Explain Normalization concept?..

Answer / neha keshri

The usual approach in normalization in database
applications is to ensure that the data is divided into two
or more tables, such that when the data in one of them is
updated, it does not lead to anamolies of data.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More MySQL Interview Questions

Which mysql function is used to concatenate string?

1 Answers  


Define REGEXP?

0 Answers  


What are the differences between binary and varbinary?

0 Answers  


What does do in mysql?

0 Answers  


Can you tell how many values can set the function of mysql to consider?

0 Answers  


What is myisam?

0 Answers  


What is the difference between primary and unique key

5 Answers   CSC,


How do I change the max connections in mysql?

0 Answers  


Explain triggers and stored procedures?

0 Answers  


How many tables will create when we create table, what are they?

2 Answers  


What is a string in mysql?

0 Answers  


Is mysql running ubuntu?

0 Answers  


Categories