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

What is the default port of mysql server?

1034

---

What is definer in mysql trigger?

915

---

How do I copy a table in mysql?

944

---

Is mysqli faster than mysql?

927

---

What is normalization and list the different types of normalization?

952

---

Does mysql support nosql?

912

---

How to drop an existing index in mysql?

1110

---

How to return query output in xml format?

1034

---

How we can get distinct columns values in mysql?

1086

---

What is a storage engine?

965

---

How to calculate the difference between two time values?

997

---

Is mariadb better than mysql?

1041

---

Do you need a license for mysql?

943

---

Explain the different types of constraints?

948

---

How to find second highest salary from a table?

1022

---