Answer Posted / 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

How do I stop a query in mysql workbench?

882

---

How to drop an existing table in mysql?

981

---

How to calculate expressions with sql statements?

1052

---

Can we write pl sql mysql?

908

---

List some comparisons operators used in mysql?

947

---

What is delimiter in mysql?

828

---

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

900

---

What is processlist in mysql?

953

---

How do I start and stop mysql server?

958

---

Is mysql a free database?

903

---

What is mysql procedure?

899

---

Why should I learn mysql?

886

---

Can mysql function return a table?

1048

---

What is session variable in mysql?

926

---

How to get the current date in mysql?

1001

---