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

Answer / neha keshri

The usual approach in normalization in database
applications is to ensure that the data is divided into two
or more tables, such that when the data in one of them is
updated, it does not lead to anamolies of data.

how we connect the data base in any programme

2 Answers  

---

what is the difrence between sql and pl/sql

21 Answers   Wipro,

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---

Explain GRANT command in MySQL.

1 Answers  

---

What is normalization and list the different types of normalization?

0 Answers  

---

---

What is required to create mysql database?

0 Answers  

---

mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?

1 Answers  

---

What is regexp?

0 Answers  

---

Write a command to list all databases in mysql?

0 Answers  

---

What sql does mysql use?

0 Answers  

---

Give the syntax of Grant and Revoke commands?

1 Answers  

---

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

0 Answers  

---