Entity Set vs Tuples vs Relation Set vs ER/Entity-Relation Model
In the Entity–Relationship (ER) model, the statement “a set of entities of the same type that share the same properties or attributes” corresponds to an Entity set.
So, among the options:
- (i) Relation set — no
- (ii) Tuples — no
- (iii) Entity set — yes
- (iv) Entity relation model — no
This is because ER modeling defines an entity as a real-world object with attributes, and an entity set as the collection of entities of the same type (sharing attributes). In contrast:
- A Tuple is used in the relational model for one row/record.
- A Relation set is a collection of tuples.
- An Entity relation model (often written ER model) is the overall modeling framework, not the specific “set of same-type entities” construct.
A visual memory hook:
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
-
(Source) Relation (relational model) definition - https://en.wikipedia.org/wiki/Relation_(database) - Defines relations as sets of tuples in relational databases. ↩
-
(Source) Tuple in relational databases - https://en.wikipedia.org/wiki/Tuple - Describes tuples as ordered collections of values (rows/records in a relational context). ↩
ER Model: Entities, Attributes, and Entity Sets (Conceptual Overview)
Key terms you’ll use to justify the correct choice are:
- Entity
- Entity set
- Attribute
- Tuple
- Relation
The phrase “entities of the same type that share same properties/attributes” maps directly to how ER diagrams group objects into an entity set. 3
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
-
(Source) Relation (relational model) definition - https://en.wikipedia.org/wiki/Relation_(database) - Defines relations as sets of tuples in relational databases. ↩
How to Pick the Correct Option (Concept Matching)
- 1Step 1
The wording uses ER concepts: entities and attributes, which strongly suggests the ER model rather than the purely relational model. 2
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
-
- 2Step 2
In ER modeling, an entity set is exactly the set of entities of the same type that share attributes. 2
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
-
- 3Step 3
Tuples represent rows/records in the relational model, and relation sets are collections of tuples. That does not match ‘entities of the same type’ wording. 2
Footnotes
-
(Source) Relation (relational model) definition - https://en.wikipedia.org/wiki/Relation_(database) - Defines relations as sets of tuples in relational databases. ↩
-
(Source) Tuple in relational databases - https://en.wikipedia.org/wiki/Tuple - Describes tuples as ordered collections of values (rows/records in a relational context). ↩
-
- 4Step 4
The entity-relation (ER) model is the overall framework describing entities and relationships, not the specific set-of-entities definition being asked. 2
Footnotes
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
-
(Source) Tuple in relational databases - https://en.wikipedia.org/wiki/Tuple - Describes tuples as ordered collections of values (rows/records in a relational context). ↩
-
Pro Tip
If a question mentions entities and attributes, it’s usually testing ER model terminology—look for entity set rather than relation or tuple. 2
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
Common Mistake
Students often confuse entity set (ER model) with relation (relational model). Entity set groups entities by type; relation groups tuples (rows). 2
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Relation (relational model) definition - https://en.wikipedia.org/wiki/Relation_(database) - Defines relations as sets of tuples in relational databases. ↩
Quick comparison table (what each option corresponds to)
| Option | Term | Model | What it represents | Match to “same type + same attributes”? |
|---|---|---|---|---|
| (i) | Relation set | Relational | A set of tuples (rows) forming a relation | No 2 |
| (ii) | Tuples | Relational | One ordered record/row of values | No |
| (iii) | Entity set | ER | Entities of the same type sharing attributes | Yes 2 |
| (iv) | Entity relation model | ER framework | Overall conceptual model (entities, relationships, attributes) | No (too broad) 2 |
Footnotes
-
(Source) Relation (relational model) definition - https://en.wikipedia.org/wiki/Relation_(database) - Defines relations as sets of tuples in relational databases. ↩
-
(Source) Tuple in relational databases - https://en.wikipedia.org/wiki/Tuple - Describes tuples as ordered collections of values (rows/records in a relational context). ↩ ↩2 ↩3
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩ ↩2
Where These Concepts Sit in Database Modeling
Model real-world objects
Conceptual (ER model)Entities with attributes are grouped into entity sets; relationships connect entity sets. 2"
Footnotes
-
(Source) Entity set definition in ER modeling - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Explains entities, entity sets, attributes and ER modeling concepts. ↩
-
(Source) Entity-relationship model concepts - https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model - Details how entity sets represent collections of entities of the same type with shared attributes. ↩
Represent data as relations
Logical (Relational model)Data becomes relations (sets of tuples/rows). 2"
Footnotes
-
(Source) Relation (relational model) definition - https://en.wikipedia.org/wiki/Relation_(database) - Defines relations as sets of tuples in relational databases. ↩
-
(Source) Tuple in relational databases - https://en.wikipedia.org/wiki/Tuple - Describes tuples as ordered collections of values (rows/records in a relational context). ↩
Knowledge Check
Which option is defined as “a set of entities of the same type that share same properties or attributes”?