1 votes 1 votes Minimum no of table for this ER diagram Databases made-easy-test-series databases er-diagram + – Gurdeep Saini asked Jan 6, 2019 edited Mar 4, 2019 by Rishi yadav Gurdeep Saini 1.1k views answer comment Share Follow See all 9 Comments See all 9 9 Comments reply adarsh_1997 commented Jan 6, 2019 reply Follow Share 3? 2 votes 2 votes Gurdeep Saini commented Jan 6, 2019 reply Follow Share yes but how you conclude it is 1 to 1 relationship ? 0 votes 0 votes adarsh_1997 commented Jan 6, 2019 reply Follow Share ( <- , ->) this represnt 1:1 relationship according to many sources. 1 votes 1 votes Nandkishor3939 commented Jan 6, 2019 reply Follow Share will you please mention the tables 0 votes 0 votes Gurdeep Saini commented Jan 6, 2019 reply Follow Share @adarsh_1997 thanks it will be more helpful if you told me these arrow for many to one ,many to many etc means arrow used for those 0 votes 0 votes adarsh_1997 commented Jan 6, 2019 reply Follow Share @Gurdeep Saini @Nandkishor3939 3 votes 3 votes Nandkishor3939 commented Jan 6, 2019 reply Follow Share @adarsh_1997 what will be the tables ? like E1R , E3R2 , E2 0 votes 0 votes prashant jha 1 commented Jan 6, 2019 reply Follow Share 3 tables , since no m:n relationship or multivalued attributes. 0 votes 0 votes eshita1997 commented Dec 20, 2020 reply Follow Share 3 tables are required for this. 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes Ans : 3 As no multivalued attributes are there . saiGate22 answered Nov 29, 2020 saiGate22 comment Share Follow See 1 comment See all 1 1 comment reply sukesh_reddy commented Mar 12, 2021 reply Follow Share This answer would not be correct when R1 or R2 is a many to many relation ship In such a case we have to create a new table for the relationship and include the primary key of both the attributes in this relation .This would lead to an extra count in the table 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Can we do so using only one table coz no entry left with null and 1 will be the minimum table..? Anoopsingh887 answered Nov 22, 2020 Anoopsingh887 comment Share Follow See 1 comment See all 1 1 comment reply computerstudy commented Mar 5, 2021 reply Follow Share When we convert this Entity Relationship Diagram in to tables then 3 tables will be required. One table for Entity E1, One Table for Entity E2 and one table for many to many relationships. To understand the full concepts of Entity Relationship Diagram Students can refers this tutorial. Entity Relationship Diagram Tutorial 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 1 table is sufficient. jitinguglani answered Feb 28, 2021 jitinguglani comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Answer should be 3. relation 1 is for (E1,E2) relation 2 is for (E2,E3) relation 3 is for E2 only as above both relation 1 and 2 have explicitly mentioned E1 and E3 and now to mention E2 we make relation 3 rish1602 answered Dec 25, 2021 rish1602 comment Share Follow See all 0 reply Please log in or register to add a comment.