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...
#181 MCQ
In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following is TRUE?
#908 MCQ
A palindrome is a word that reads the same forwards and backwards. In a game of words, a player has the following two plates painted with letters. From...
#1 MCQ

Related Topics

ER model Relational model 3NF Database normalization ER to relational mapping GATE Computer Sciences 2015 GATE CS 2015 Q49 minimum relations in 3NF

Unique Visitor Count

Total Unique Visitors

Loading......