64 votes 64 votes Consider the following $\text{ER}$ diagram The minimum number of tables needed to represent $M$, $N$, $P$, $R1$, $R2$ is $2$ $3$ $4$ $5$ Databases gatecse-2008 databases er-diagram normal + – Kathleen asked Sep 11, 2014 edited Jun 4, 2021 by Arjun Kathleen 26.2k views answer comment Share Follow See all 10 Comments See all 10 10 Comments reply Show 7 previous comments nishant_magarde commented Nov 25, 2018 reply Follow Share 3NF 0 votes 0 votes yagneshmb commented Dec 14, 2020 reply Follow Share If you want to check your knowledge of ER diagram then do this question 0 votes 0 votes Harpuneet Kalsi commented Aug 12, 2021 reply Follow Share Is R1 one to many or many to one relation? 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes Relationship between M & P is N:1 so solve Accordingly . The Side which Has "Arrow" has Cardinality = 1 always.(Remember That). amcodes18 answered Feb 16, 2020 amcodes18 comment Share Follow See 1 comment See all 1 1 comment reply worldfrom6feet commented Jan 5, 2021 reply Follow Share It would be better if you post it with proper Source. There is no such mention in any of the standard textbooks. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes ans is c.4 m(m1m2m3) pr1r2(p1p2m1n1) n1(n1n2) n2(n1) kvkumar answered Jun 2, 2016 kvkumar comment Share Follow See all 0 reply Please log in or register to add a comment.