To put the definition of an entity is an entity is a single person, place, or thing about which data can be stored. That is in other words for example when one wants to store information about STUDENT then it has details like studentno, student name, address for communication, phone number, class of the student and so on. All of these details together is placed in the entity or table called as STUDENT. The entities may have relationship between the entities. Say for instance the above STUDENT entity may have relationship between the entity named as COURSE. A student may be enrolled in more than one course thus forming the relationship ‘is enrolled in’ between the two entities STUDENT and COURSE. The database stores all the values of entities and relationships.
Attribute is the characteristic property of an existing entity. The attribute has two parts in it namely the attribute instance and attribute type. Attribute type is the column name or field name that is in the above student entity student name is the attribute type and the actual value stored in it is the attribute instance. Say for instance the value “Exforsys” stored as student name in the attribute type is the attribute instance.
What is the difference between entity and attribute?
To put the definition of an entity is an entity is a single person, place, or thing about which data can be stored. That is in other words for example when one wants to store information about STUDENT then it has details like studentno, student name, address for communication, phone number, class of the student and so on. All of these details together is placed in the entity or table called as STUDENT. The entities may have relationship between the entities. Say for instance the above STUDENT entity may have relationship between the entity named as COURSE. A student may be enrolled in more than one course thus forming the relationship ‘is enrolled in’ between the two entities STUDENT and COURSE. The database stores all the values of entities and relationships.
Attribute is the characteristic property of an existing entity. The attribute has two parts in it namely the attribute instance and attribute type. Attribute type is the column name or field name that is in the above student entity student name is the attribute type and the actual value stored in it is the attribute instance. Say for instance the value “Exforsys” stored as student name in the attribute type is the attribute instance.
Questions by GeekAdmin answers by GeekAdmin
Related Answered Questions
Related Open Questions