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 edit a database in mysql workbench?

948

---

How many tables we can create in mysql database?

992

---

Is mysql deprecated?

962

---

What is federated tables in mysql?

952

---

What is logs in mysql?

947

---

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

967

---

In mysql, what is joins? Explain

1025

---

How do I disable mysql?

992

---

In which language it is written?

1004

---

What is meant by mysqli?

952

---

How can I connect mysql database?

941

---

can you tell the order of sql select statement? : Mysql dba

950

---

What is the phantom problem?

1041

---

How can you create and drop view in mysql?

968

---

What is the purpose of using timestamp data type?

971

---