2 votes 2 votes if two entities A and B are connected using total participation with relation R then minimum number of tables required in relational model is? Ankita Shingala asked Dec 26, 2016 Ankita Shingala 716 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
3 votes 3 votes If both entities have total participation then one table is sufficient.. kirti singh answered Dec 26, 2016 kirti singh comment Share Follow See all 9 Comments See all 9 9 Comments reply sudsho commented Dec 26, 2016 reply Follow Share if cardinality is m:n with total participation then also u need 1 table only? 0 votes 0 votes kirti singh commented Dec 26, 2016 reply Follow Share No.. that's for 1:1 cardinality .. for m:n cardinality would require two separate table for entities but no table for relationship... am I correct? 0 votes 0 votes dd commented Dec 26, 2016 reply Follow Share I think We should keep all tables ..separately. 4 votes 4 votes sudsho commented Dec 26, 2016 reply Follow Share @kriti singh @Debashish has done right..we'll need 3 tables for m:n....2 or entities and 1 for relationship...doesnt matter u have total participation or partial!! 2 votes 2 votes vijaycs commented Dec 26, 2016 reply Follow Share @Debashis,..very nice (y).. now.. can you please convert your comment to ans ?? 1 votes 1 votes dd commented Dec 26, 2016 reply Follow Share have to show all cases !! leave it !! ..comments ...above ans + below answer ..would be ok for now ! ..later I will provide Or someone will provide explanation for all. 0 votes 0 votes User007 commented Feb 4, 2017 reply Follow Share If relationship is 1:1 and total participation exists only on one side , then can we merge both tables ? 0 votes 0 votes sudsho commented Feb 4, 2017 reply Follow Share ^no.... 1 votes 1 votes srivivek95 commented Dec 3, 2017 reply Follow Share @User007 If relationship is 1:1 then for total participation on either one side or both sides we can merge the tables 0 votes 0 votes Please log in or register to add a comment.