ER to relation

Question

Answer has R4 and E2 merged, I cant visualize how? what will be primary key? What will be other attributes?

Comments

is the answer 7.

if it is then the tables are  :

R3E3(D,F,G,E)

E2R4(D,D,E)

E2(D,E)

E1(A,B,C)

R!(A,D)

R2(A,D)

Here, underlined are foreign keys.

please correct me if i am wrong.

---

No,  read this
https://www.geeksforgeeks.org/mapping-from-er-model-to-relational-model/amp/

Answer 1

I think the answer is 5 correct me if i am wrong

for e1 an e2 m:m relation require 2 foreign key

for e1 and e2 1:m relation for same table require 1 FK

for e2  R4 require 1 fk

for e3 require one fk coz of weak entity

so total of 5 FK require

Comments

if question is asked for no. of table then total number of table will be 4.

table 1 for E1

table 2 for E2

table 3 for E3

table 4 for M:N relationship.

Answer 2

E1,E2,E3 and R1 will require 1 table so total 4 table will be required.