0 votes 0 votes Answer has R4 and E2 merged, I cant visualize how? what will be primary key? What will be other attributes? Databases relations databases er-diagram er-to-relational + – bts1jimin asked Jan 16, 2019 bts1jimin 553 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply OneZero commented Jan 16, 2019 i edited by OneZero Jan 16, 2019 reply Follow Share 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. 0 votes 0 votes bts1jimin commented Jan 18, 2019 reply Follow Share No, read this https://www.geeksforgeeks.org/mapping-from-er-model-to-relational-model/amp/ 0 votes 0 votes Please log in or register to add a comment.
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 Anoopsingh887 answered Jul 7, 2019 Anoopsingh887 comment Share Follow See 1 comment See all 1 1 comment reply BASANT KUMAR commented Oct 2, 2019 reply Follow Share 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. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes E1,E2,E3 and R1 will require 1 table so total 4 table will be required. Shailendra_ answered Oct 15, 2019 Shailendra_ comment Share Follow See all 0 reply Please log in or register to add a comment.