3 votes 3 votes Minimum number of tables required for above diagram ________ Databases databases er-diagram + – Anjan asked Jan 30, 2018 Anjan 1.7k views answer comment Share Follow See all 14 Comments See all 14 14 Comments reply Raveena Yadav 1 commented Jan 30, 2018 reply Follow Share ans is 4 0 votes 0 votes Raveena Yadav 1 commented Jan 30, 2018 reply Follow Share E3R4 E1R1E2R2 R3 E4R5 3 votes 3 votes Anjan commented Jan 30, 2018 reply Follow Share why E1 and E2 are merged both are strong entities ryt?? one table for each ....? 0 votes 0 votes Raveena Yadav 1 commented Jan 30, 2018 reply Follow Share Because of total participation 0 votes 0 votes raviyogi commented Jan 30, 2018 i edited by raviyogi Jan 30, 2018 reply Follow Share @anjan just follow these rules , you will be easily solve these questions. CASE --->ONE-ONE A. Both sides partial participation { E1<---R-->E2 } In this case you can merge R either side . so two table will be required. A. Both sides total participation { E1<==R==>E2 } In this case you can merge all in a single table . so only 1 table will be required. A. one sides total participation { E1<==R--->E2 } In this case also you can merge all in a single table . so only 1 table will be required. read this and then try to answer the above ques . THE ans is 4 . { E3R4 , E1R1E2R2 ,R3, E4R5 } CASE --->1-m A. { E1<---R------E2 } In this case relation will be merged with the entity having ONE mapping , So we got two table ( E1 ,E2R) CASE --->n-m A. { E1-----R------E2 } In this case relation can not be merged with the any entity ,and we got 3 tables ( E1 ,E2, R) where R stores the foreign key to both E1 and E2. 10 votes 10 votes Anjan commented Jan 30, 2018 reply Follow Share Thanks a lot :) 1 votes 1 votes gauravkc commented Jan 30, 2018 reply Follow Share Thanks bro :) Very helpful 1 votes 1 votes Utsav09 commented Jan 30, 2018 reply Follow Share why ans is not 5? 0 votes 0 votes $ruthi commented Jan 30, 2018 reply Follow Share i got 5 0 votes 0 votes vishal chugh commented Jan 31, 2018 reply Follow Share @raviyogi Isn't there any effect of Total Participation in One to Many and Many to Many relationships? 0 votes 0 votes raviyogi commented Jan 31, 2018 reply Follow Share no effect@vishal 0 votes 0 votes chandan sahu commented Dec 6, 2018 reply Follow Share @raviyogi tell me what will be the minimum of relation required for M:1 relationship if the 1 side is fully participated. its going to one na. 0 votes 0 votes Harsh Kumar commented Dec 12, 2018 reply Follow Share @raviyogi Dear, can you provide a reference where are the rules for merging the two "Entity" Sets given (in cases of total participation)? I did not find any such rules in Korth's book (Sixth Edition). Thank You. 0 votes 0 votes Shivam Kasat commented Jan 13, 2019 reply Follow Share @raviyogi does this rules you explained above applicable for weak entity depending on a strong entity? 0 votes 0 votes Please log in or register to add a comment.