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 are the constraints on severity level in raiseerror?

0 Answers  

In which database can extended stored procedures be added?

0 Answers  

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

0 Answers  

Write short notes on manual refreshes.

0 Answers  




Explain about relational database management systems?

0 Answers  

Explain about the relational database?

0 Answers  

can you give me the syntax of named procedure??

2 Answers  

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

2 Answers  

Given an employee table, how would you find out the second highest salary?

9 Answers  

Explain about normal forms?

0 Answers  

How you can make a parameterized view?

0 Answers  

For more DB Development Interview Questions Click Here
Categories