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

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3883

---

What is 'mysqld'?

876

---

What is mysql workbench used for?

927

---

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

978

---

What is database engine in mysql?

887

---

How to Set a root password if there is on root password.

1020

---

What you can use regular expression for in mysql?

874

---

What does innodb stand for?

924

---

What are date and time intervals?

922

---

How does limit work in mysql?

850

---

Write a query to find duplicate rows in table?

854

---

How to delete a database from mysql server.

986

---

What is mysql_query?

794

---

Write a command to view mysql database table structure?

919

---

What are views in mysql?

871

---