1 votes 1 votes Minimum number of relations or tables required ? Databases databases er-diagram + – Xylene asked Sep 19, 2017 Xylene 1.5k views answer comment Share Follow See all 8 Comments See all 8 8 Comments reply Habibkhan commented Sep 19, 2017 reply Follow Share Is the answer given 4 ?? If so plz let me know I will explain then.. 0 votes 0 votes Xylene commented Sep 19, 2017 reply Follow Share Even I think it should be 4, but the answer given is 5 :( . Anyway, can you just explain it ? I want to know if what I am thinking is correct.@Habibkhan 0 votes 0 votes Habibkhan commented Sep 20, 2017 reply Follow Share I think they have not merged the entity E3 with R6E5 though it is in total participation..May be due to the fact that it is a strong entity. In that case number of tables needed (minimum) is 5.. 0 votes 0 votes Xylene commented Sep 20, 2017 reply Follow Share But it should be 4 right as we can merge R3 E3 R6 and have combined PK as (FH) ? 0 votes 0 votes Habibkhan commented Sep 20, 2017 reply Follow Share I think we cannot merge strong entity with weak entity.. 1 votes 1 votes Xylene commented Sep 20, 2017 i edited by Xylene Sep 20, 2017 reply Follow Share Ok, Suppose if E5 would have been strong entity and participation of M would have been partial then can we merge R3 E3 R6 ? If yes, then what would be the new PK? @Habibkhan 0 votes 0 votes Habibkhan commented Sep 20, 2017 reply Follow Share No I think we cannot merge in that case as well as R6 is a weak relationship.. 1 votes 1 votes Xylene commented Sep 20, 2017 reply Follow Share Just consider that it's a strong relationship. I want to just know if we can merge in that case. 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes 7 relations are required KIRTI12345 answered Dec 20, 2017 KIRTI12345 comment Share Follow See all 0 reply Please log in or register to add a comment.