GATEverse
← GATE CSE 2015 Set 1

Q41

NAT2 marks

Consider an Entity-Relationship (ER)(\text{ER}) model in which entity sets E1E_{1} and E2E_{2} are connected by an m:nm:n relationship R12R_{12}. E1E_{1} and E3E_{3} are connected by a 1:n1 : n (11 on the side of E1E_{1} and nn on the side of E3E_{3}) relationship R13R_{13}. E1E_{1} has two-singled attributes a11a_{11} and a12a_{12} of which a11a_{11} is the key attribute. E2E_{2} has two singled-valued attributes a21a_{21} and a22a_{22} of which a21a_{21} is the key attribute. E3E_{3} has two single-valued attributes a31a_{31} and a32a_{32} of which a31a_{31} is the key attribute. The relationships do not have any attributes. If a relational model is derived from the above ER\text{ER} model, then the minimum number of relations that would be generated if all relation are in 3NF\text{3NF} is________________.

Sign in to save attempts.

Loading…