553 views
0 votes
0 votes

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

2 Answers

5 votes
5 votes
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

Related questions

1 votes
1 votes
0 answers
1
Na462 asked Nov 14, 2018
667 views
0 votes
0 votes
0 answers
2
Na462 asked Oct 12, 2018
1,127 views
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ?A. 1B. 2C. 3D. 4
1 votes
1 votes
0 answers
3
Mk Utkarsh asked Sep 23, 2018
663 views
Tables needed for ER diagram
1 votes
1 votes
0 answers
4
bts1jimin asked Aug 30, 2018
1,271 views