{"id":5070,"date":"2021-08-16T13:04:37","date_gmt":"2021-08-16T07:34:37","guid":{"rendered":"https:\/\/www.goseeko.com\/blog\/?p=5070"},"modified":"2026-02-05T13:22:23","modified_gmt":"2026-02-05T07:52:23","slug":"what-is-the-er-model","status":"publish","type":"post","link":"https:\/\/www.goseeko.com\/blog\/what-is-the-er-model\/","title":{"rendered":"What is the ER Model?"},"content":{"rendered":"\n

The Entity-Relationship model<\/a> (ER model) is a type of entity-relationship model. It’s a data model at a high level. The data items and relationships for a given system are define using this model.<\/p>\n\n\n\n

It creates a database’s conceptual design. It also creates a very simple and easy-to-design data view. Further, The database structure is depict as a diagram called an entity-relationship diagram in ER modelling.<\/p>\n\n\n\n

Components of ER model<\/strong><\/h2>\n\n\n\n
    \n
  1. Entity\u00a0<\/strong><\/li>\n<\/ol>\n\n\n\n

    An entity is an object, location, person, or event that stores data in a database. Additionally, A rectangle represents an entity in an object-relationship diagram.<\/p>\n\n\n\n

    Entity type: <\/strong>An entity type is a list or a collection of things that share specific characteristics. In addition, Each type of entity in a database is define a name and a set of attributes.<\/p>\n\n\n\n

    Entity set: <\/strong>It’s a group (or collection) of similar entities with shared qualities or properties.<\/p>\n\n\n\n

    2. Attribute<\/strong> <\/h2>\n\n\n\n

    An attribute in an Entity-Relationship Model defines the traits or characteristics of an entity. An oval or ellipse shape is use in the ER diagram to symbolize it. Additionally, Each oval form represents a different attribute and is linked to the person in the rectangle shape.<\/p>\n\n\n\n

    Simple attribute:<\/strong> A simple attribute is calling an attribute which contains an atomic value and can not be divided further.<\/p>\n\n\n\n

    Key attribute:<\/strong> An attribute that can uniquely identify an entity in an entity set is known as a key attribute. Moreover, In the ER diagram, it represents a primary key. On the other hand, The key attribute is represent by an ellipse with an underlying line in an Entity Relationship diagram.<\/p>\n\n\n\n

    Composite attribute:<\/strong> A composite attribute is an attribute that is made up of two or more basic attributes. Moreover, An ellipse in an Entity-Relationship diagram defines it, and that ellipse is made up of additional ellipses.<\/p>\n\n\n\n

    Derived attribute: <\/strong>An attribute which can derive from other attributes is refers to as a derived attribute. Meanwhile, A dashed oval shape is use to represent these attributes in an entity-relationship diagram.<\/p>\n\n\n\n

    Multivalued attributes:<\/strong> An attribute that has several values for a particular entity.<\/p>\n\n\n\n

    3. Relationship<\/strong> <\/h2>\n\n\n\n

    Therefore, In the Entity-Relation Model, a relationship is use to define the relationship between two or more entities. In the ER diagram, it is illustrate by a diamond shape. <\/p>\n\n\n\n

    Degree of Relationship<\/strong><\/p>\n\n\n\n

    Degree of relationship can be categorize into the following types:<\/p>\n\n\n\n