4 votes 4 votes Find minimum number of tables needed? Answer : (3) Can anyone please explain the answer and how to approach such complex er diagrams? Databases databases er-diagram made-easy-test-series + – vk_9_1_9 asked Jan 26, 2019 edited Mar 3, 2019 by ajaysoni1924 vk_9_1_9 866 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply shriram s 1 commented Jan 29, 2018 reply Follow Share Is it 5? E1(A,B,C,D) E2(D,E,F,G) E3(G,H,G) E4(I,J,K,A) R3(G,A) 1 votes 1 votes Sumaiya23 commented Jan 29, 2018 reply Follow Share That's what even I got...but the answer given is 4..and I can't understand how 0 votes 0 votes balchandar reddy san commented Jan 30, 2019 reply Follow Share 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.. 0 votes 0 votes codingo1234 commented Sep 8, 2019 reply Follow Share E1E2R1R2(A,B,C,D,E,F,G) G IS FK FROM E3 TO E2 R3(AG) BOTH 'A' AND 'G' ARE FK TO E1 AND E3 E4R5(I,J,K,A) 'A' IS FK TO E1 E3R4(G,H,M) 'M' IS AS FK REFERENCING PK G BOLD ONES ARE PRIMARY KEY, is it correct?? 1 votes 1 votes BASANT KUMAR commented Oct 2, 2019 i edited by BASANT KUMAR Oct 2, 2019 reply Follow Share 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. 0 votes 0 votes Please log in or register to add a comment.