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

Difficulty: Easy

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.

More Questions from Data Modeling with ER Model

Discussion & Comments

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