1 votes 1 votes If two tables A and B given with relationship table R. Min number of tables possible if below conditions given 1) R is 1:1 2) R is m:n 3)R is 1:m 4)R is m:1 5)total participation of A in R 6)total participation of A and B both in R Databases relational er-to-relational er-diagram relational-algebra + – learner_geek asked Dec 2, 2017 learner_geek 486 views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Anu007 commented Dec 2, 2017 reply Follow Share When both side partial: 1) R is 1:1 = 2 minimum 2) R is m:n = 3 minimum 3)R is 1:m = 2 minimum 4)R is m:1 = 2 minimum 5)total participation of A in R 1) R is 1:1 = 1 minimum 2)R is 1:m = 2 minimum 3)R is m:1 = 2 minimum 6)total participation of A and B both in R 1) R is 1:1 = 1 minimum 2)R is 1:m = 1 minimum 3)R is m:1 = 1 minimum 3 votes 3 votes learner_geek commented Dec 2, 2017 reply Follow Share Is this correct or we need to make MR table 0 votes 0 votes sachin486 commented Dec 14, 2020 reply Follow Share can you provide any refference brother 0 votes 0 votes Please log in or register to add a comment.