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.