edited by
4,746 views
1 votes
1 votes
We can convert any weak entity set to a strong entity set by simply adding appropriate attributes. Why, then, do we have weak entity sets at all?

 $1)$ We want to avoid the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity

 $2)$ Weak entities reflect the logical structure of an entity being dependent on another entity

$3)$Weak entities can be deleted automatically when their strong entity is deleted

What is/are the possible correct reasons from the above:

$A)1$ and $2$                                            $B)2$ and $3$

$C)1$ and $3$                                            $D)1,2$ and $3$
edited by

1 Answer

4 votes
4 votes

We can convert any weak entity set to a strong entity set by simply adding appropriate attributes.Why, then, do we have weak entity sets?


Answer :We have weak entities for several reasons:

  •  We want to avoid the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity.

  •  Weak entities reflect the logical structure of an entity being dependent on another entity.

  •  Weak entities can be deleted automatically when their strong entity is deleted.

  • Weak entities can be stored physically with their strong entities.


 

Related questions

0 votes
0 votes
1 answer
2
ankitgupta.1729 asked Dec 16, 2017
1,243 views
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...
0 votes
0 votes
3 answers
3
uzumzki asked Aug 17, 2015
1,918 views
R(ABC)     S(BDE)F:A->B      B ->C     B->D     D->EAND R HAS 100 TUPLES AND S HAS 200
0 votes
0 votes
1 answer
4