How do you implement one-to-one, one-to-many and many-to- many relationships wh

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

Question Posted / guest

1 Answers
9161 Views
Flextronics, Hexaware, SQL Star, I also Faced
E-Mail Answers

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

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

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

0 Answers

What is DB Development software?

0 Answers

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers

How long can an error message be in raiseerror function?

0 Answers

Explain about network model?

0 Answers

Explain about normal forms?

0 Answers

what is the use of foreginkey