Gateforum

Question

PLZZ HELP...

ANS IS GIVEN 3...I AM GETTING 2....

Consider the er diagram in which 2 entities E1,E2 participate in one to one relation R where the participation of the entity set E2 is total. The attributes of E1 are A1, A2, A3 where A1,A2 is singe valued and A3 is multivalued. The attribute of E2 are B1,B2,B3,B4 and all of them are single valued. The minimum number of tables required to convert ER into relational table.........

Answer 1

Here in this can we can not combine table E1 and E2 because the required condition is one to one relationship and both side total participation..but here total participation is only on E2 side

So 3 tables required

(Assuming that A1 is primary key in E1 and B1 is primary key in E2)

Table 1(A1,A2) , Table of entity E1

Table 2(A1,A3) , Table of multivalued attribute A3 , Here A1 is foreign key and Primary of the table is A1A3.

Table 3(B1,B2,B3,B4,A1), Table of E2. Here we have A1 as foreign key for the relationship R...

Comments

Two tables for the two attributes, where the relation itself can be added to any of the side.

---

@KunuSwavik 

Two table required for two entities and the relationship can be merged with total participation side. 

There is one multivalued attribute for which we need separate table.

so total 3 table required.

---

Yes, you are correct, but my ans is not regarding this specific question where there is a multivalued attribute, I have answered this for a general case where there is no multivalued attribute. If there is a multivalued attribute then you are absolutely correct.