Answer / ashu_deepu

normalisation is nothing but the technique of removing duplicates or redundant data from the table .

the degree of normalisation is dependent on the user.

Answer / bikash khuntia

Normalization means the process in which raw data is
converted to filtered data.
Types of Normalization are:- 1NF,2NF,3NF.

1NF:- Table that contains one or more repeating groups
Identify and remove repeating groups.

2NF:-Describes a table that is fully functionally dependent
Full functional dependency – means that if B is
functionally dependent on A but not on any proper subset of
A, it is fully functionally dependent on A
Partial dependency – is if there are some attributes from A
that can be removed and the dependency still holds

3NF:- In 3NF we remove the transitive dependencies.
Transitive dependency – A->B and B->C implies that A->C
C is transitionally dependent on A through B

what is difference between sap and oracle applications and which is now market leader?

11 Answers   Amity, Infosys, Rysigo, Unilogic Software, Wipro,

---

what is thae main difference between foreingkey and primarykey

5 Answers  

---

I have table that has student names in it.If I query on the names my result set should return as 'VALUE NOT ENTERED' for null entries.

1 Answers  

---

what is difference between sqlserver and oracle?

5 Answers   CMC,

---

what is normalization

2 Answers   NIC,

---

---

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

0 Answers   Canara Bank,

---

in fun why return single value?

1 Answers   UST,

---

can we use a having cluase in groupby clause. if there are 500 records i will give rownumber<250 then how many records does it retrieve. wt is the result of nvl2(null,notnull,null) if there are four tables without using cartesian how many joins can be there. in the sql subqueries wt is the parent ans1)select 2)update,3) delete 4)2&3

2 Answers   i2,

---

what are collection attributes

1 Answers   GE,

---

REGULAR CLASSES for Informatica 8.6 is starting from Monday, 07th Nov, 8:00 AM IST .

1 Answers  

---