Consider an Entity-Relationship (ER) model in which entity sets \(E_1\) and…

PYQ GATE 2015

Consider an Entity-Relationship (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 (1 on the side of E1E_1 and nn on the side of E3E_3) relationship R13R_{13}.

E1E_1 has two single-valued attributes a11a_{11} and ​​a12​​a_{12} of which a11a_{11} is the key attribute. ​​​​E2​​​​E_2 has two singlevalued 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 model, then the minimum number of relations that would be generated if all the relations are in 3NF is _______.

Attempted by 461 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…