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 Normalization?

6 Answers   TCS,

Explain the process of the user request and data generating?

0 Answers  

How to create an external table.

1 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  

Write short notes on XSU and JAVA

1 Answers  




hi in which phase of mload can i use .FILLER

1 Answers   IBM,

What are the key features of dbms?

0 Answers  

how to find the first two highest salaries in deptno in emp table

2 Answers  

Who are naive users?

0 Answers  

In which table collections errors are stored.

0 Answers  

Explain about normal forms?

0 Answers  

What is a self join? Explain it with an example?

16 Answers   TCS,

For more DB Development Interview Questions Click Here
Categories