GATE | GATE-CS-2017 (Set 2) | Question 16

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


Answer: (C)

Explanation: In one to many or many to one participation, relation is merged in table which is on many side and if there is total participation then relation is merged in that side.

Therefore, option C is correct

Quiz of this Question



My Personal Notes arrow_drop_up