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.

What is ole db provider for sql server?

0 Answers  

---

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

0 Answers  

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

---

Differentiate between extension & intension?

0 Answers  

---

How much does it cost to build a database?

0 Answers  

---

---

What do you mean by database?

0 Answers  

---

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

0 Answers   Accenture,

---

what is vlook up in ms excel and how does it used???

1 Answers   CybAge,

---

What is the relationship that exists inside in E-R diagram?

0 Answers   CGI,

---

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

0 Answers   3i Infotech,

---

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,

---

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

0 Answers   Amazon,

---