The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+1 vote








asked in Databases by Loyal (6.2k points) | 732 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.
answered by Veteran (414k 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...

Related questions

0 votes
1 answer
asked Jan 31, 2016 in DS by nilamd Junior (593 points) | 456 views
+3 votes
0 answers
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
49,811 questions
54,528 answers
75,480 users