Skip to content
Related Articles

Related Articles

GATE | GATE MOCK 2017 | Question 32
  • Last Updated : 06 Jan, 2017

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
Recommended Articles
Page :