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 ?

  1. A.

    Generalization

  2. B.

    Aggregation

  3. C.

    Specialization

  4. 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.

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…