2 votes 2 votes Databases databases er-diagram + – worst_engineer asked Oct 3, 2015 worst_engineer 2.2k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 3 votes 3 votes 3 tables reqd two store entites E1 and E.2 relationship R1 can be stored in E2 table one more table is required for Relationship R2 which is many to many so ans is 3 Pooja Palod answered Oct 3, 2015 • selected Dec 20, 2016 by saurabh rai Pooja Palod comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes For many - to -many = Min 3 RDBMS table required For one to many = Min 2 RDBMS table required here we need MIN 3 table 1+ for E1 + 1 for R2 + 1 for E2R1 =3. Umang Raman answered Oct 3, 2015 Umang Raman comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes 3 tables. There will b one more table for the relation which is many to many... Hence 1-1 table for E1 and E2 and one for the R2. Yash_Pandey answered Feb 23, 2018 Yash_Pandey comment Share Follow See all 0 reply Please log in or register to add a comment.