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 does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

919

---

What is the use of pdo?

927

---

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4644

---

How do you create a primary key?

989

---

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1069

---

Explain about the architecture of MYSQL?

958

---

What is the default password for mysql?

874

---

Create table employee (eno int(2),ename varchar(10)) ?

990

---

Is mysql a server or database?

872

---

What is save point in mysql?

940

---

How do I connect to mysql database?

1025

---

What is the default port for MySQL Server?

1058

---

What is the default port for mysql and how it can change?

1039

---

What is a heap table?

929

---

How do I know if mysql is installed on windows?

897

---