{"id":865,"date":"2019-12-10T11:32:22","date_gmt":"2019-12-10T06:02:22","guid":{"rendered":"https:\/\/binaryterms.com\/?p=865"},"modified":"2021-01-18T12:34:06","modified_gmt":"2021-01-18T07:04:06","slug":"difference-between-entity-and-attribute-in-database","status":"publish","type":"post","link":"https:\/\/binaryterms.com\/difference-between-entity-and-attribute-in-database.html","title":{"rendered":"Difference Between Entity and Attribute in Database"},"content":{"rendered":"

Entity and attribute are the most common terms of DBMS. The fundamental difference between the entity and attribute is that an entity<\/strong> is an object that exists in a real-world and can be easily distinguished among all other objects of real-world whereas, the attributes<\/strong> define the characteristics or the properties of an entity on the basis of which it is easily distinguishable among other entities of the real-world.<\/p>\n

In the relational database, we collect the data in the form of a table. So, the rows<\/strong> of a table represent the entities of the same type and the columns<\/strong> of a table are considered as attributes of the entities present in that table. In this section, we will discuss some more differences between an entity and attribute with the help of a comparison chart. We will also discuss entity and attribute in brief.<\/p>\n

Content: Entity Vs Attribute<\/h2>\n
    \n
  1. Difference Chart<\/a><\/li>\n
  2. What is an Entity in DBMS?<\/a><\/li>\n
  3. What is Attribute in DBMS?<\/a><\/li>\n
  4. Key Differences<\/a><\/li>\n
  5. Summary<\/a><\/li>\n<\/ol>\n

    <\/a><\/p>\n

    Difference Chart<\/h3>\n

    \n\n\n\n\t\n\n\t\n\t\n\t\n\t\n\t\n\t
    Basis of Differentiation<\/th>Entity<\/th>Attribute<\/th>\n<\/tr>\n<\/thead>\n
    Basic<\/td>An entity is a distinguishable real-world object that exist.<\/td>An attribute describes the elementary feature of an entity.<\/td>\n<\/tr>\n
    Relational Data Model<\/td>In the relational data model, an entity is represented as a record in an entity set.\u00a0<\/td>In the relational data model, a field represents an attribute.<\/td>\n<\/tr>\n
    Table<\/td>A row in a database table is an entity.<\/td>A column header of a database table is an attribute.<\/td>\n<\/tr>\n
    Grouping<\/td>Entities of similar type are placed in one entity set\/table.<\/td>Group of attributes that easily identifies a tuple forms a key.<\/td>\n<\/tr>\n
    Refinement<\/td>An entity can be a tangible entity or an intangible entity.<\/td>Each attribute has a certain domain and it may be involved in forming a key.<\/td>\n<\/tr>\n
    Example<\/td>A student tuple in a student table in the database represents an entity.<\/td>Name, roll number, Id, Address, these fields of student table presents the attribute of student entity.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n<\/a><\/p>\n

    What is Entity in Database?<\/h3>\n

    An entity<\/b> is a distinguishable real-world\u00a0 \u2018object\u2019 that exists. An object should not be considered as an ‘entity’ until it can be easily identified from all other objects of the real world. In a database, only that ‘thing’ or ‘object’ is considered as an entity about which data can be stored<\/strong> or retrieved<\/strong>.\u00a0 As if you are not able to store data about some object or if you are not going to retrieve data about some object then there is no point in creating that entity in a database.<\/p>\n

    The entities sharing the same set of properties or same set of attributes are kept in one entity set<\/strong> which is also known as a relation<\/strong> or a table <\/strong>in the relational database. An entity in an entity set is represented by the sequence of attributes values which is simply a sequence of values hence, it is also called as a tuple<\/strong>.<\/p>\n

    In the relational model, each entity sets are represented by a table<\/strong>. So, each row<\/strong> of a table in the database represents an entity<\/strong>. It is essential that a table must not contain duplicate entities as it will lead to ambiguity. Each entity in a table must be uniquely identified which means two entities in a relation, should not contain the same set of values for the same set of attributes. An entity can be anything that exists in real-world like it can be a person, thing, place, object, event,\u00a0 etc.<\/p>\n

    An entity is further classified into two types, i.e. tangible<\/strong> entity and intangible<\/strong> entity:<\/p>\n

      \n
    1. A tangible entity<\/strong> is one which physically<\/strong> exists in real-world. Such as a person, student, bank locker, etc. are examples of tangible entities, we can touch them as they physically exist.<\/li>\n
    2. An intangible entity<\/strong> is one which exists logically<\/strong> in real-world such as bank account, reservation, email account etc. Like a tangible entity, we can easily identify the intangible entity such as a bank account has an account no. using which we can easily identify that bank account, but we cannot touch it, as it doesn’t exist physically in the real world.<\/li>\n<\/ol>\n

      The figure below shows the entities in the student table:<\/p>\n

      \"Entity<\/p>\n

      As you can see in the figure above we have five entities in the student<\/strong> table. Though we have two students with the same name \u2018Jhoson\u2019 we can easily distinguish among them because they have a distinct<\/strong> roll number. So, we conclude that the entities are the real-world objects that are easily distinguishable.
      \n      <\/a><\/p>\n

      What is Attribute in DBMS?<\/h3>\n

      Attributes<\/strong> describe the characteristics or properties of an entity in a database table. An entity in a database table is defined with the ‘fixed’ set of attributes. For example, if we have to define a student entity then we can define it with the set of attributes like roll number, name, course. The attribute values, of each student entity, will define its characteristics in the table.<\/p>\n

      In a relational database, we store data in the form of tables<\/strong>. The column<\/strong> header of the table represents the attributes<\/strong>. A table must not<\/strong> have duplicate<\/strong> attributes. Each attribute in a table has a certain domain<\/strong> which allows it to accept a certain ‘set of values’ only. In an entity, each attribute is allowed to have only one value which could be a number, text, date, time etc. (defined in SQL standard).<\/p>\n

      Attributes have further refinement such as keys<\/strong>. A single attribute or a set of attributes that can distinguish an entity in an entity set\/relation is termed as key<\/strong>. In the database, we have a primary key, super key, composite key, foreign key. All of them are created with a certain purpose to normalize a relation in the database.<\/p>\n

      Observe the figure below it shows the attributes of the student table:<\/p>\n

      \"Attributes<\/p>\n

      As you can see in a student table we have three attributes Roll No., Name and Course. The attribute values of each student entity define its characteristics in the table, which in turn help us to identify each student entity in the student table uniquely.
      \n      <\/a><\/p>\n

      \n

      Key Differences Between Entity and Attribute<\/h3>\n