Minimum no. of table required:
Relationship Type |
Participation |
# of Tables |
1-1 |
Both Side Partial |
2 |
1-1 |
1: Partial 1: Full |
1 |
1-m |
Both Side Partial |
2 |
1-m |
1: Full m: Partial |
1 |
1-m |
1: Partial m: Full |
2 |
m-m |
Both Side Partial |
3 |
m-m |
m: Partial m: Full |
2 |
m-m |
Both Side Full |
1 |
m-1 relationship behave like 1-m .
This question belongs to the 2 categories:
R1 :- it's 1-m(Both side Partial) relationship which need 2 tables 1 table foe E1 and other for E2(combine with R1 )
R2:- it's m-m(Both side Partial) relationship which need 3 tables 1 table for E1 , 1 table for R2 & 1 table for E2 . but E1 and E2 is already counted so, only remaining R2 is required .
Min. no. of table :- E1,E2,R2 = 3