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:
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