Explain Normalization concept?

Question Posted / pranab

2 Answers
10396 Views
Inuva, I also Faced
E-Mail Answers

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

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers

What is the difference between a database and a table?

0 Answers

Give the syntax of Grant and Revoke commands?

1 Answers

How do you flush privileges?

0 Answers

What is myisamchk?

0 Answers

How to rename an existing table in mysql?

0 Answers

How do I create a new database in mysql?