ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  DB Development
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
Answer
# 1		 
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 ?    3 Yes 0 No
Ramesh
 

 
 
 
Other DB Development Interview Questions
 
  Question Asked @ Answers
 
What are cursors? Explain different types of cursors?  3
how will I find the duplicate rows count from employees tablein oracle.  1
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? SQL-Star1
What are defaults? Is there a column to which a default can't be bound?  1
Define candidate key, alternate key, composite key?  6
What is the system function to get the current user's user id?  1
What is normalization? Explain different levels of normalization? IBM2
What is a self join? Explain it with an example?  2
Explain the general syntax for a SELECT statements covering all the options.  2
What is bit datatype and what's the information that can be stored inside a bit column?  2
What is denormalization and when would you go for it?  2
Given an employee table, how would you find out the second highest salary?  4
What are the disadvantages of cursors? How can you avoid cursors?  1
what is Normalization? TCS2
What is an extended stored procedure?  1
 
For more DB Development Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com