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.

List the properties of a transaction.

0 Answers  

---

What is dialect in database?

0 Answers  

---

what is meant by Dynamic query?

3 Answers   Satyam,

---

How default key is different from primary key?

0 Answers   Abacus,

---

What are different types of data models available? Explain with example?

0 Answers   Accenture,

---

---

What is a Transformation?

0 Answers   Informatica,

---

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,

---

How does non-cluster index functions?

0 Answers   Alcatel-Lucent,

---

What is the default identifier of structure in C?

3 Answers   CybAge,

---

Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,

---

Is it possible to update AS400 database record while reading it with no lock

1 Answers  

---

what is tkprof tool and how it is used???

0 Answers   Genpact,

---