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 fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  

---

What is the main difference b/w Teradata and Oracle?

1 Answers   TCS,

---

What are the tools used for backup and ticketing?

0 Answers   Alcatel-Lucent,

---

issues involved in modeling and building data werahouses

0 Answers  

---

plz suggest me the books for the preparation of NIC written exam.

4 Answers   NIC, Rolta,

---

What are the advantages of views in a database?

0 Answers  

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

0 Answers   3i Infotech,

---

If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?

3 Answers   CTS,

---

Explain database partitioning.

0 Answers  

---

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  

---

How many types of normalization? What is the use of it?

0 Answers   Accenture,

---

What is database schema name?

0 Answers  

---