ER model to relational model - 1:1 relationship


Two entity sets A and B have one to one relationship. Now consider the following cases -

1) A has PP and B has PP

2) A has PP and B has TP

3) A has TP and B has PP

4) A has TP and B has TP

Where TP - Total Participation & 

             PP - Partial Participation.


Answer the following questions for each case - 

a) number of tables

b) primary key and foreign key in each of the table


Please explain with the help of example.

Shraddha @shraddhagami
14 Jan 2017 08:39 pm

Number of tables: 2