retagged by
777 views

1 Answer

Best answer
11 votes
11 votes
one for A,B,C,R1,R3 and one for R2.

 

Why I have merged them bcoz B and C participate totaly with one to one particapation in R3. Hence can be merged giving BC.

Now BC participates totally with one to one particapation in R1 with A. Hence can be merged -->ABC

R2 is m:n ---> Needs a separate table.

At end we have ABC entity set having a self relationship of cardinality m:n.
selected by

Related questions

3 votes
3 votes
2 answers
1
1 votes
1 votes
6 answers
2
Abbas2131 asked Jul 30, 2018
2,238 views
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?
1 votes
1 votes
0 answers
3
learner_geek asked Dec 2, 2017
471 views
If two tables A and B given with relationship table R.Min number of tables possible if below conditions given1) R is 1:1 2) R is m:n3)R is 1:m4)R is m:1 5)total participa...