Home » Database » Database miscellaneous » Question

Database miscellaneous

  1. 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 of which is the key attribute. E3 has two singlevalued attributes a31 and a32 of which a31 is the key attribute. The relationships do not have any attributes. If a relational model is the derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is _______.
    1. 21
    2. 5
    3. 7
    4. 0
Correct Option: B


E1 (a11, a12), E2 (a21, a22), E3 and R13 (a11, a31, a32), R2 (a11 , a12), But in table (a11, a31, a32) there may be transitive dependency between a11 and a32 so we should decompose this table into 2 more tables.



Your comments will be displayed only after manual approval.