Answer / shahnaz

Normalization is used to improve the performance of database and is applied in the last step of logical database design.The Goal of Normalization is to
1.Eliminate the duplicate data from table
2.Ensure data dependency

we can achieve this by creating multiple tables for each set and by creating primary and foreign keys and building relationship between the newly created tables.

Answer / dhivya

when large amount of data required in database we need to find important data.
In normalization there will be important primary keys that must merge together so that we kind find the relations of the keys.
Eg. trans Id,video,cust ID
cust ID be the primary key in customer table
eg. cust ID, name, address, phone no, mail id 

Answer / rizwana

To decompose a large relation into two or more relations then we can use normalization

What is the use of prepared statement?

0 Answers  

---

What are stuff and replace function?

0 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

How do you pronounce sql?

0 Answers  

---

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

What is procedure explain with program?

0 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

What is a primary key? Explain

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

How to create an array in pl/sql?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---