1 votes 1 votes The minimum number of tables needed to represent M,N,P,R1,R2 is … The given ans is 2. I think the ans should be 3. Databases databases er-diagram made-easy-booklet + – Harsh Kumar asked Dec 11, 2018 edited Mar 5, 2019 by ajaysoni1924 Harsh Kumar 1.1k views answer comment Share Follow See all 3 Comments See all 3 3 Comments reply Hemanth_13 commented Dec 12, 2018 reply Follow Share I think MR1P --->M1 & P1 as PK NR2----->P1 N1 as PK 0 votes 0 votes Harsh Kumar commented Dec 12, 2018 reply Follow Share Why merge M and P... there can be null values in the final relation..!! 0 votes 0 votes Hemanth_13 commented Dec 12, 2018 reply Follow Share They asked min number of tables, there can be null values in that case 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes Yes it is possible such that R1 (M1,M2,M3) and R2 (P1,P2,N1, N2). I also think the answer is 3 but this explanation given Made easy test series. Because the second relationship is identifying relationships . Raj Kumar 7 answered Dec 25, 2018 Raj Kumar 7 comment Share Follow See all 2 Comments See all 2 2 Comments reply Harsh Kumar commented Dec 25, 2018 reply Follow Share Bro, even if the second relationship is identifying relationship, it does not ensure the merging of P and N - all it can ensure is merging of R2 and N. Please provide me with any standard references like a book or some instructors blog etc. 0 votes 0 votes Raj Kumar 7 commented Dec 25, 2018 reply Follow Share @ Harsh https://db.grussell.org/section006.html Subsumes the entity concept. 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes https://gateoverflow.in/390/gate-cse-2008-question-82 inswer is 3 mohit jain answered Jan 20, 2023 mohit jain comment Share Follow See all 0 reply Please log in or register to add a comment.