598 views
1 votes
1 votes

Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity..

plz clarify this........

1 Answer

1 votes
1 votes
clearification of above statement is in two ways

(a) weak entity is totally participated in strong entity i.e. each element of weak entity is must have some element in strong entity

but weak entity have not its own primary key it is identified by primary key of strong entity

(b) suppose if we duplicate the weak entity set then we have to duplicate the primary key as we know that primary key must contain unique value which is not possible so there will be contradiction here

Related questions

4 votes
4 votes
1 answer
1
radha gogia asked Jul 26, 2015
3,186 views
1:1 1:M M:1 M:N
0 votes
0 votes
1 answer
2
radha gogia asked Jul 5, 2015
500 views
Cross Edge(a,b) is defined as an edge between two non-ancestor nodes in DFS , so my query is that how is this stmt true :arrival[b] <departure[b] <arrival[a] <departure[a...
0 votes
0 votes
0 answers
3
codingo1234 asked Apr 8, 2019
248 views
Can a weak entity depend on more than one strong entity?If yes then how does that exaclty work?
0 votes
0 votes
0 answers
4
Abhishek Malik asked May 27, 2018
626 views
Why there is always $1:M$ relationship between a strong entity set and a weak entity set ,why not $M:1$ and $M:N$?