Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
408 views
in Structuring Database for Accounting by (15.2k points)

What do you mean by Entity Type? How it is different from entity set?

Please log in or register to answer this question.

1 Answer

0 votes
by (15.7k points)

Entity Types and Entity Sets 

An entity type is defined as a collection of entities, which share a common definition in terms of their attributes. Each entity type is assigned a name for its subsequent identification. The attributes of entity type are used to describe it in the database. The value of attributes of an entity belonging to entity type are known as “Entity Instance”.

An entity set is a collection of all entity instances of a particular entity type. An entity type is described by a set of attributes called “Schema”. The set of entities pertaining to a particular entity type share the same set of attributes. The collection of entities of a particular entity type is grouped into entity set, called the extension of the entity type.

For example: Entity type: Accounts

Structure of entity type:

Code Name Type

Entity set: Collection of entity instances of an entity 

Extension or Instances of entity type:

Code Name Type
71011 Captial Account 4
221019 Sunil & Co. 4
632001 Bank Account 3

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...