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.

What is a table schema?

0 Answers  

---

Is mysql query case sensitive?

0 Answers  

---

How to return query output in xml format?

0 Answers  

---

How do I enable mysqli extension?

0 Answers  

---

What is striped backup

0 Answers   Cap Gemini,

---

What is MySQL Stored Procedure?

1 Answers  

---

What is the difference between primary key and candidate key?

0 Answers  

---

How many ways we can retrieve the date in result set of mysql using php?

0 Answers  

---

about foregine

2 Answers  

---

How can we get total number of records by query in mysql?

0 Answers  

---

How important is to list the column names when doing an insert?

0 Answers  

---

how to repair a table in mysql?

2 Answers  

---