ER to Table Conversion

Question

Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?

Answer 1

1. 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/

Comments

agreed :)

---

@srestha

@Prashant.

please add more points here like what to do in case 1:N and N:M relationship with/without total participation.

Answer 2

See if this is helpful

http://users.cms.caltech.edu/~donnie/dbcourse/intro0607/lectures/Lecture17.pdf

Comments

Watch techtud tutorials on YouTube