in Databases
2,435 views
0 votes
0 votes

The Answer is 3. But I think only 2 are required as R2 is many(E3) to one(E1) with total participation.

Thus tables formed E2R1(DFA) with pk as DA. R2(GHABC) with pk as G.

in Databases
by
2.4k views

1 comment

https://db.grussell.org/section006.html#_Toc67114436

To map 1:m relationships, the primary key on the `one side' of the relationship is added to the `many side' as a foreign key.

If an entity type participates in several 1:m relationships, then you apply the rule to each relationship, and add foreign keys as appropriate.

Hence 3 tables are required. 

0
0

1 Answer

0 votes
0 votes
Ans can't be two table, because all are strong entity representing.

But there is a case possible where 1:1 with total participation in E3,E2 then we could make 1 table for both E2 and E3 combined one.

As per your concept for 1:M is not possible, because it violates the relational model property which is multi valued attributes can't holds.

Related questions