Computer Sciences > GATE 2015 SET-1 > ER Model
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 a21 is the key attribute. E3 has two single-valued attributes a31 and a32 of which a31 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 _______.
Correct : 4
Similar Questions
An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which of the fo...
An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which of the fo...
An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which of the fo...
Total Unique Visitors
Loading......