1 votes 1 votes Any Good Resource to study this topic ? Or Could anyone explain this topic to me ? Databases er-diagram rdbms databases + – PEKKA asked Nov 29, 2016 PEKKA 1.4k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 6 votes 6 votes If both the entities having total participation in 1:1 relationship then we only require 1 table named of relation this is the case in which we can say that only one table is required. Reference: http://www.techtud.com/sites/default/files/public/lec7.pdf page 18 with highlighted part that supports this statement. 2. If there is total participation on any one side between two entities in 1:1 relationship then we need at least 1 table . Reference: http://www.geeksforgeeks.org/minimization-er-diagram/ ( there should be no arrow in total participation, notation use in this link is not correct for 1:1 total participation , only " = " should be there.) 3. 1:1 with both sides partial participation require 2 tables . Reference : http://www.edugrabs.com/conversion-of-er-model-to-relational-model/ And some sources to study these concepts http://www.cs.toronto.edu/~ryanjohn/teaching/cscc43-s14/slides/er-database-v01.pdf http://www.learndb.com/databases/how-to-convert-er-diagram-to-relational-database http://www.geeksforgeeks.org/minimization-er-diagram/ http://www.edugrabs.com/conversion-of-er-model-to-relational-model/ Bikram answered Jul 7, 2017 selected Aug 31, 2017 by Bikram Bikram comment Share Follow See all 2 Comments See all 2 2 Comments reply Prashant. commented Jul 7, 2017 reply Follow Share agreed :) 0 votes 0 votes jlimbasiya commented Jan 10, 2020 reply Follow Share @srestha @Prashant. please add more points here like what to do in case 1:N and N:M relationship with/without total participation. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes See if this is helpful http://users.cms.caltech.edu/~donnie/dbcourse/intro0607/lectures/Lecture17.pdf Sachin Tripathi answered Jul 6, 2017 edited Jul 7, 2017 by Bikram Sachin Tripathi comment Share Follow See 1 comment See all 1 1 comment reply Vishal Goyal commented Jul 6, 2017 reply Follow Share Watch techtud tutorials on YouTube 0 votes 0 votes Please log in or register to add a comment.