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

How to display all Friday's in a year with date?

4 Answers   Flipkart,

---

what are the join types in tsql? : Transact sql

0 Answers  

---

Is sql better than access?

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

What are two statement types in sql?

0 Answers  

---

What is the difference between left and left outer join?

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What does rownum mean in sql?

0 Answers  

---

Is id a reserved word in sql?

0 Answers  

---

How do you explain an index number?

0 Answers  

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---