Open In App

GATE | GATE MOCK 2017 | Question 32

Like Article
Like
Save
Share
Report

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


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads