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

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.

Can I install mysql on mac?

0 Answers  

---

how we can use more then one primary key in Single Table

9 Answers   Systematix,

---

What is the difference between SQL and SQL Server?

3 Answers   Cognizant, HCL,

---

How to declare variable in mysql trigger?

0 Answers  

---

In how many ways we can retrieve data in the result set of mysql using php?

0 Answers  

---

How do I insert an image into mysql workbench?

0 Answers  

---

what if you really want to store the timestamp data, such as the publication date of the article?

2 Answers  

---

What is flush privileges in mysql?

0 Answers  

---

Which mysql function is used to concatenate string?

1 Answers  

---

how to know the tables in database having foreign key?

2 Answers  

---

If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?

0 Answers  

---

What is delimiter in mysql?

0 Answers  

---