The Gateway to Computer Science Excellence
+2 votes








in Databases by Loyal (6.3k points) | 781 views

1 Answer

+3 votes
Best answer
A weak entity it self doesn't have a primary key and depends on the strong entity to form a primary key. For example EMPLOYEE can be a strong entity and DEPENDENT a weak entity. An employee can have multiple dependents and a dependent can have multiple concerned employees. So, the relationship is M:N, with the participation of weak entity being TOTAL- there is no dependent without a concerned employee.
by Veteran (422k points)
selected by
Sir, but there can be total participation of weak entities when the relationships are other than M:N also..i think sir it depends on the requirement analysis....please correct me if wrong..
Sir and EMPLOYEE and DEPENDENT is generally 1:M
Total participation is irrespective of whether it is 1:N or M:N. Because there can be no dependent without the corresponding Employee.

To be clear, DEPENDENT is Dependent of

So, one employee can be dependent of many other employees. Also, same employee can depend on multiple other employees. Hence, M:N. But, this is just an example- the main thing is the relationship between weak entity and strong entity can be M:N.
relationship can be 1:M,1:1 and M:1 also..righ sir? because total participation is independent of the this correct

yes. but we should say M:N because of all possibilities.
ok got it sir...thank you..

So, one employee can be dependent of many other employees

Also, same employee can depend on multiple other employees. Hence, M:N. 

here both entities are employees so they both are strong  none of them is weak.

Arjun sir, if it is m:n, in that case we won't be able to uniquely identify weak has to be 1:m...pls correct me..
Sir, If M:N relationship is possible, how to generate table for the weak entity set? Do we have to introduce a third table? If so,  will weak entity set continue to have partial keys alone? Please clear my confusion sir...
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,666 questions
56,167 answers
93,998 users