What kind of mechanism is to be taken into account for converting a weak…
2014
What kind of mechanism is to be taken into account for converting a weak entity set into strong entity set in entity-relationship diagram ?
- A.
Generalization
- B.
Aggregation
- C.
Specialization
- D.
Adding suitable attributes
Attempted by 238 students.
Show answer & explanation
Correct answer: D
Answer: Adding suitable attributes — give the weak entity a primary key so it no longer depends on an owner entity for identification.
Step 1: Identify or create an attribute (or combination of attributes) that can uniquely identify each instance of the weak entity.
Step 2: Promote this attribute or attribute set to be the primary key of the entity (so it becomes a strong entity).
Step 3: Once a full primary key exists, the identifying relationship and owner dependency are no longer required for identification; update the ER diagram and schema accordingly.
Note: A weak entity initially lacks a full primary key (it has a partial key and depends on an owner). Making it strong means it has its own full primary key.
Why other mechanisms are not appropriate:
Generalization: This combines entity sets into a supertype; it does not provide a unique identifier for a dependent weak entity.
Aggregation: This models a relationship as an abstract entity for nesting relationships; it does not resolve the identification dependency of a weak entity.
Specialization: This creates subtypes and handles inheritance of attributes, but it does not by itself grant a weak entity an independent primary key.