In entity–relationship modeling, what do we call an attribute that uniquely names or identifies instances of an entity?

Database Data Modeling with ER Model Difficulty: Easy
Choose an option
  • A
    entity.
  • B
    attribute.
  • C
    identifier.
  • D
    relationship.
  • E
    foreign key.

Answer

Correct Answer: identifier.

Explanation

Introduction / Context:Every entity type should have at least one attribute (or set of attributes) that uniquely distinguishes its instances. This unique naming/identifying concept underpins keys in relational tables derived from the ER model.

Given Data / Assumptions:

  • An entity has many instances (rows in a derived table).
  • One attribute or combination must uniquely identify each instance.
  • The ER term is being asked.

Concept / Approach:The ER term for the unique naming attribute(s) is identifier. When mapped to the relational model, an identifier typically becomes a candidate key; the chosen one becomes the primary key. Identifiers can be natural (business meaning) or surrogate (system-generated).

Step-by-Step Solution:

Match the role (uniqueness) to the ER term → identifier.Map to relational schema → candidate key / primary key.Ensure uniqueness constraint is enforced in DDL.

Verification / Alternative check:Standard ERD notations label identifying attributes with key symbols or unique markers.

Why Other Options Are Wrong:Entity: The set/type being modeled, not the naming attribute. Attribute: General column; not necessarily unique. Relationship: Connects entities; does not name them. Foreign key: An attribute that references another entity's identifier; not the entity's own identifier.

Common Pitfalls:Confusing identifiers with descriptions. A description may not be unique; an identifier must be.

Final Answer:identifier.

Discussion & Comments
No comments yet. Be the first to comment!
Join Discussion