Question 24Asked in UGC NET Computer Science, June 2015 (Paper II & III, Selected Questions)
Which of the following statements is FALSE about weak entity set?
AWeak entities can be deleted automatically when their strong entity is deleted
BWeak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the strong entity
CA weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included
DTuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set
Show answerHide answer
Correct answer: (D) Tuples in a weak entity set are not partitioned according to their relationship with tuples in a strong entity set
Explanation
We have weak entities for several reasons : • We want to avoid the data duplication and consequent entity. Possible inconsistencies caused by duplicating the key of strong. • Weak entities be stored physically with their strong entities • Weak entities can be detected automatically when their strong entity is detected. So (d) is incorrect statement, Hence (d) is the answer.
From UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions)