in Databases
480 views
1 vote
1 vote
If two tables A and B given with relationship table R.

Min number of tables possible if below conditions given

1) R is 1:1

2) R is m:n

3)R is 1:m

4)R is m:1

5)total participation of A in R

6)total participation of A and B both in R
in Databases
480 views

3 Comments

When both side partial: 

1) R is 1:1 = 2 minimum 
2) R is m:n =  3 minimum  
3)R is 1:m = 2 minimum 
4)R is m:1 = 2 minimum


5)total participation of A in R 

1) R is 1:1 = 1 minimum 
2)R is 1:m = 2 minimum 
3)R is m:1 = 2 minimum 

6)total participation of A and B both in R

1) R is 1:1 = 1 minimum 
2)R is 1:m = 1 minimum
3)R is m:1 = 1 minimum

3
3

Is this correct or we need to make MR table

0
0
can you provide any refference brother
0
0

Please log in or register to answer this question.