Answer / ramesh

One to one
Parent Entity does have one Corresponding record in Child
Entity

ex : Employee and his CV

One to many

Parent Entity does have many Corresponding records in Child
Entity

ex : Employee and his Projects

many to many

Parent Entity records do have many Corresponding records in
Child Entity vice versa

ex : Employees and Employers
Employees Receive Calls from Many Employers
Employers Receive CVs from Many Employees

What is an extended stored procedure?

1 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me

1 Answers   IBM,

---

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

0 Answers  

---

Who are end users in dbms?

0 Answers  

---

Why does this query return 0?

0 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

What is an application role and explain a scenario when you would use one?

0 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

What are the main phases of database development?

0 Answers  

---