What is difference between Entities and Entity sets? Explain with example.

Question

Suresh Chand · Accepted Answer

Entity: An entity is a real-world thing that can be distinctly identified as a person, place, or concept. It is an object which is distinguishable from others. If we cannot distinguish it from others then it is an object but not an entity. Example: If we have a table of a Student (Roll_no, Student_name, Age, Mobile_no) then each student in that table is an entity and can be uniquely identified by their Roll Number i.e Roll_no. Entity Set: Entity Set is a collection of entities of the same entity type. In the above example of the STUDENT entity type, a collection of entities from the Student entity type would form an entity set. Example 1: In the below example, two entities E1 (2, Angel, 19, 8709054568) and E2(4, Analisa, 21, 9847852156) form an entity set. The difference between Entities and Entity sets are Entity Entity Set A thing in the real world with independent existence Set of all entities of a particular entity type. Any particular row (a record) in a relation(table) is known as an entity. All rows of a relation (table) in RDBMS are entity set

What is difference between Entities and Entity sets? Explain with example.

Leave your Answer:

Hits Counter

Question

What is difference between Entities and Entity sets? Explain with example.

Leave your Answer: