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