in Databases edited by
3,623 views
1 vote
1 vote
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$
in Databases edited by
by
3.6k views

1 comment

D????
1
1

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