edited by
2,035 views
4 votes
4 votes

Please explain how they merged.(Modified)

edited by

2 Answers

Best answer
4 votes
4 votes

1 table for E2
1 table for E3
1 table for (E1R E4 )
E1 has total participation with R, it needs no seperate table.
1:1 with only single side total participation we always take 1 table.


so in total 3 tables require here.

edited by
1 votes
1 votes
Plz check my answer:
E2{ C,D,A,B }
E3{ E,F, A, B}
E4{ G,H,A,B}

Explanation:
A has total participation in R.
So no need of seprate table.
And R has 1:M relationship with all other tables so no need to maintain seprate table for R.

Correct me if I'm wrong!
Answer:

Related questions

4 votes
4 votes
3 answers
1
4 votes
4 votes
0 answers
2
vk_9_1_9 asked Jan 26, 2019
867 views
Find minimum number of tables needed?Answer : (3)Can anyone please explain the answer and how to approach such complex er diagrams?
1 votes
1 votes
0 answers
4
Shivam Kasat asked Jan 13, 2019
609 views
NO. OF RELATIONS REQURIED FOR THIS ER-DIAGRAM:I am getting answer 1,Reference :https://gateoverflow.in/201404/er-diagram read out @raviyogi comment