ER model minimum number of tables

Question

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

Comments

answer :C

---

see this once https://gateoverflow.in/218954/what-an-interesting-dbms-question

Answer 1

ANSWER IS C.

AS minimum no. of tables is 2 when there is 1:1 and 1: N relationship.

AS WE DONT NEED NEW TABLE WHEN WE HAVE THESE DEPENDENCIES

while in the case of M:N we need one extra table as when attribute on relation itself we dont know which side to put that attribute so we make extra table for that

Comments

According to my understanding multivalued attribute requires extra table.

But i think each multivalued attribute over same entity doesn't require one table.(it takes only one extra table for an entity in case of multivalued attr).

Please correct me if i'm wrong. I am new in this subject.

---

@Deepanshu,

why can't we make the original table primary key as (sid, ph_no) then also each row uniquely identified

 

But i think each multivalued attribute over same entity doesn't require one table.(it takes only one extra table for an entity in case of multivalued attr).

for this, what your answer?

---

But i think each multivalued attribute over same entity doesn't require one table.(it takes only one extra table for an entity in case of multivalued attr).

FOR THIS FROM MY POINT OF VIEW, EVERY MULTIVALUED ATTRIBUTE CONTAINS EXTRA TABLE.