Entity vs. attribute: Is an attribute defined as a person, place, object, or event in the user environment?

Difficulty: Easy

Correct Answer: Incorrect

Explanation:


Introduction / Context:
Clear distinction between entities and attributes is foundational to ER modeling. Confusing the two leads to poor schemas and query complexity.



Given Data / Assumptions:

  • An entity is a person, place, object, event, or concept about which data is stored (e.g., Customer, Product, Order).
  • An attribute is a property that describes an entity (e.g., customer_name, product_price).
  • The statement mislabels the definition.



Concept / Approach:
The phrase “person, place, object, event” defines an entity, not an attribute. Attributes are characteristics of entities or relationships. Getting this right ensures proper table design: entities typically become tables; attributes become columns; relationships become foreign keys or associative tables.



Step-by-Step Solution:
List the nouns central to the business domain—these are candidate entities.For each entity, list descriptive properties—these are attributes.Assign primary keys to entities; define data types and constraints for attributes.Model relationships between entities with appropriate cardinalities.



Verification / Alternative check:
Try mapping “Order” to a table (entity) and “order_date” to a column (attribute). If you reverse them, design breaks down quickly.



Why Other Options Are Wrong:
Dimensional or normalization level does not change the fundamental definitions.



Common Pitfalls:
Promoting an attribute to an entity prematurely (or vice versa); using vague attribute names like “name” without context.



Final Answer:
Incorrect

Discussion & Comments

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