Q. 51 Consider an Entity-Relationship (ER) model in which entity sets E1 and E2 are
connected by an m : n relationship R12, E1 and E3 are connected by a 1 : n (1 on
the side of E1 and n on the side of E3) relationship R13.
E1 has two single-valued attributes a11 and a12 of which a11 is the key attribute. E2
has two single-valued attributes a21 and a22 is the key attribute. E3 has two singlevalued
attributes a31 and a32 of which a31 is the key attribute. The relationships
do not have nay attributes.
If a relational model is derived from the above ER model, then the minimum
number of relations that would be generated if all the relations are in 3NF is
______.
(A) 2
(B) 3
(C) 4
(D) 5
Answer: (C)
Explanation:
