MadeEasy Full Length Test 2019: Databases - Er Diagram

Question

Find minimum number of tables needed?

Answer : (3)

Can anyone please explain the answer and how to approach such complex er diagrams?

Comments

T1 - E1,R1,E2  (1:1 and total participation from E1)

T2 - E3,R2,R4

T3 - R3 (M:N)

T4 - E4,R5

I think the answer is 4, can anyone tell me what else can be clubbed among these..

---

1. E1E2R1R2(A,B,C,D,E,F,G) G IS FK FROM E3 TO E2
2. R3(AG) BOTH  'A' AND 'G' ARE FK TO E1 AND E3 
3. E4R5(I,J,K,A) 'A' IS FK TO E1
4. E3R4(G,H,M)  'M' IS AS FK REFERENCING PK G

BOLD ONES ARE PRIMARY KEY, is it correct??

 

---

i think it will be 4

table 1 for E1 and E2 (it can be combined).

table 2 for E3

table 3 for E4

table 4 for M:N relationship

total 4 table.