1,430 views

2 Answers

Best answer
6 votes
6 votes
  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/

selected by

Related questions

0 votes
0 votes
0 answers
3
Shamim Ahmed asked Dec 18, 2018
305 views
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ?1:1 with partial participation of both entities needs min no of tables = 2?
3 votes
3 votes
2 answers
4