Answer / ajeet khari

normalization is organizing data efficiently into database...
main thing is 1.elimination of redundant data,2. data
dependencies..
1NF-a table is decomposed into 2D table with no duplicate
column....
2nd NF- should be in 1NF and there should not be any
duplicate row...
3NF- should be in 2NF and contains transitive dependencies
remove that column which are not dependent on PK.
4NF-should be in 3NF and it has no malti valued dependencies.

How to do Data integrity testing? Who does this testing (Developer or tester)?

0 Answers  

---

can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.

1 Answers  

---

how node connect with cpu?

0 Answers   IBM,

---

How does database replication work?

0 Answers  

---

What is lagging in DBMS ?

0 Answers   Hexaware,

---

---

Data structure used to implements a menu:

0 Answers   Verifone,

---

What is Object Oriented model?

0 Answers   Thomson Reuters,

---

if i want to display the name of students such that to which city they belong must have count greaer than two

0 Answers   Atos Origin,

---

Differentiate between unique key and foreign key?

0 Answers   CGI,

---

What is a database call?

0 Answers  

---

how do you do sql tuning?

0 Answers   Systel,

---

Explain various types of locks in a transaction? Which is better and why?

0 Answers   Agilent,

---