+ 6

What is the difference between entity, entity set and attribute in SQL?

DBMS (Sql)

24th Feb 2019, 5:25 PM
Yashi Jain
Yashi Jain - avatar
4 ответов
+ 4
Entity is a real world object , whereas entity set is a collection of more than one entities. And attribute is the property or a behaviour an entity posess. For e.g. In college , B.tech is an entity, whereas B.Sc,B.com ,MBA and B.tech combines to form an entity set. Now B.tech have these things like Stream(civil,mechanical,Cs etc), Subjects, projects etc.these are called Attributes. A basic knowledge of entity,entity set and attributes is necessary in making E-R Diagram which is further significant when you are working on some project and you have to show the basic functionalities of your project.
24th Feb 2019, 6:49 PM
Salman Ahmad
Salman Ahmad - avatar
+ 1
An entity is a table or object that can be distinguished from other An entityset is a collection of entities of same table type Attribute is a column in a relation A relation must contain minimum of 1 attribute or multiple attributes based upon customer request
25th Feb 2019, 4:57 AM
sree harsha
sree harsha - avatar
+ 1
In basic knowledge in SQL data base manipulation system
27th Feb 2019, 3:33 AM
Jeevan Jeevan
Jeevan Jeevan - avatar
0
efujnni
7th Mar 2019, 4:01 AM
Àiltaf Hussain
Àiltaf Hussain - avatar