Computer Sciences > Gate 2017 Set-2 > ER model
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 following conditions, can the relational table for R be merged with that of A?

(A) Relation R is one-to-many and the participation of A in R is total.
(B) Relation R is one-to-many and the participation of A in R is partial.
(C) Relation R is many-to-one and the participation of A in R is total.
(D) Relation R is many-to-one and the participation of A in R is partial.
A
A
B
B
C
C
D
D

Correct : ER model

Similar Questions

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
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 s...
#1137 NAT
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 database GATE computer science 2017 entity relationship diagram one to many relation partial participation total participation relational algebra database design questions

Unique Visitor Count

Total Unique Visitors

Loading......