GATE | GATE MOCK 2017 | Question 32

What is the min and max number of tables required to convert an ER diagram with 2 entities and 1 relationship between them with partial participation constraints of both entities?

(A) Min 1 and max 2

(B) Min 1 and max 3

(C) Min 2 and max 3

(D) Min 2 and max 2

Answer: (C)

Explanation: Maximum number of tables required is 3 in case of many to many relationships between entities. Minimum number of tables is 1 in case of unary relationship and total participation of atleast one entity. But in case of partial participation of both entities, minimum number of tables required is 2.

Quiz of this Question

My Personal Notes arrow_drop_up

Article Tags :

Be the First to upvote.

Please write to us at to report any issue with the above content.