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?

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

Solution

Correct Answer: Option C