More Questions from Data Modeling with ER Model

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