Machine-translated by Google. Questions are authored in English.
Top

Discussion

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

  • A.The weak entity set MUST have total participation in the identifying relationship
  • B.The owner entity set MUST have total participation in the identifying relationship
  • C.Both weak and owner entity sets MUST have total participation in the identifying relationship
  • D.Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

Answer: A

The true statement is The weak entity set MUST have total participation in the identifying relationship.

A weak entity has no key of its own; it is identified only through its owner, by combining the owner's key with its partial key. So every weak entity must be linked to an owner through the identifying relationship, which is total participation.

The owner need not participate totally: an employee may have no dependents, for example, so not every owner entity has a related weak entity. That rules out the options requiring total participation of the owner, and 'neither' is wrong because the weak side's participation is required.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.