Database Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 4335 Page Views: 

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

Posted By: Avi Date: 7 October 2009 02:51:09 AM

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.

One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.

Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Posted By: eTechPlanet

Date: 7 October 2009 02:51:09 AM
Post a better Answer if you have
(Will show your Gravatar icon)  
  Country flag

Enter the text as shown in the image TsGcWW
Related Questions
Database : What is the purpose of Triggers?

What is the purpose of Triggers?

Triggers are some set of business rules. It consist of some set of commands or statements like Store....
Category: Database Date: 10/1/2010 10:59:06 AM
Database : What is DKNF?

What is DKNF?

DKNF is one of the Normalization forms. It is Domain-Key Normal Form(DKNF). According to this normal....
Category: Database Date: 10/1/2010 10:58:06 AM
Database : Why is De-normalisation Required?

Why is De-normalisation Required?

Fully normalized database can only be attained at logical level. Truly normalized databse can not be....
Category: Database Date: 10/1/2010 10:57:06 AM
Database : What do you mean by normalization?

What do you mean by normalization?

Basically normalization is a process in realational databse design to organise the data and avoid da....
Category: Database Date: 10/1/2010 10:56:06 AM
Database : I have 1-year gap between my 10th & 12th. So what should I answer regarding this?