Answer / Anjali Devi

A many-to-many relationship between two tables can be physically represented in three ways: 1) Using a junction table (associative entity) with foreign keys to both original tables. 2) By embedding one-to-many relationships in each of the original tables as self-referential foreign keys. 3) Through inheritance, where one or more intermediate tables are created to represent the relationship.

what is Normalization?

6 Answers   TCS,

---

What is normalization? Explain different levels of normalization?

9 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

---

What is a database development?

1 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What are the three basic rules which are to be followed for the relational model of the database?

1 Answers  

---

Can you have a nested transaction?

1 Answers  

---

Explain about the hierarchical model of the database?

1 Answers  

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

How to generate OIDS

1 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1 Answers  

---

Which data type cannot be used as a parameter in a udf?

1 Answers  

---