1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

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

Question Posted / guest


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

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

Is This Answer Correct ?    12 Yes 6 No

Post New Answer

More DB Development Interview Questions

What is a join and explain different types of joins?

2 Answers  

What are the 18 schemas?

0 Answers  

agregator gives one to many records or many to one record

1 Answers   IBM,

How can I detect whether a given connection is blocked?

0 Answers  

Explain about a primary key?

0 Answers  




Explain about the hierarchical model of the database?

0 Answers  

What are cursors? Explain different types of cursors?

6 Answers  

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

What is an extended stored procedure?

1 Answers  

How to use online Backups?

0 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,

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

For more DB Development Interview Questions Click Here
Categories