edited by
5,592 views
6 votes
6 votes

Which of the following statements is false about weak entity set?

  1. Weak entities can be deleted automatically when their strong entity is deleted
  2. Weak entity set avoids the data duplication and consequent possible inconsistencies caused by duplicating the key of the string entity
  3. A weak entity set has no primary keys unless attributes of the strong entity set on which it depends are included
  4. Tuples in a weak entity set are not partitioned according to their relationship with tuples with a strong entity set
edited by

3 Answers

Best answer
4 votes
4 votes
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 reect the logical structure of an entity being dependent on another entity.
  •  Weak entities can be deleted automaticallywhen their strong entity is deleted.
  •  Weak entities can be stored physically with their strong entities.

D is incorrect statement. so the choice will be D.

 

selected by
1 votes
1 votes
Weak entity set is one which does not have any primary key..

(a) is true because weak entity set does not have any existence without strong entity in database. For every entry of weak entity we have corresponding strong entity entry in DB.

let we have employee(strong) and family(weak) as entity sets.

(b)can be false because weak entity set does not have their own primary key so it can have duplication and inconsistency problem that's why it needs strong entity always and hence called as dependent entity.

(c) is obviously true

(d) is true because there is no relationship of tuple partitioning b/w weak and strong entity sets
0 votes
0 votes
option D is the correct answer because tuples in a weak entity set are partitioned according to their relationship with tuples with a strong entity set.
Answer:

Related questions

2 votes
2 votes
2 answers
1
go_editor asked Jul 30, 2016
15,493 views
For a weak entity set to be meaningful, it must be associated with another entity set in combination with some of their attribute values, is called as:Neighbour SetStrong...
1 votes
1 votes
1 answer
3
go_editor asked Jul 30, 2016
2,567 views
Drop Table cannot be used to drop a Table referenced by _______ constraintPrimary keySub keySuper keyForeign keyaa, b and cda and d
2 votes
2 votes
1 answer
4