0 votes 0 votes Consider the following ER diagram The minimum number of relations tables required for above ER diagram are __________ . User007 asked Jan 17, 2017 User007 669 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes E1RE2(A' ,B, C,D',E,F,G)---------------------(1) ------------------------------------------------------------- E3R2(G',H,D)----------------------(2) here 2 table is required. Hradesh patel answered Jan 17, 2017 edited Jan 17, 2017 by Hradesh patel Hradesh patel comment Share Follow See all 10 Comments See all 10 10 Comments reply Show 7 previous comments User007 commented Jan 17, 2017 reply Follow Share Thanks Hradesh. But I have got one more doubt. By double lines we can say that Participation is Total and hence Minimum Cardinality is 1. But how can we comment about relationship being One-One unless we know that Maximum cardinality of both tables is 1. Which symbol did you refer to, to conclude that Max cardinality of both tables is 1? Please guide. Thanks a lot. 0 votes 0 votes Supremo commented Jan 19, 2017 reply Follow Share see @Hardesh it says defferent http://www.edugrabs.com/conversion-of-er-model-to-relational-model/ 0 votes 0 votes User007 commented Jan 20, 2017 reply Follow Share Hradesh has also said the same. 0 votes 0 votes Please log in or register to add a comment.