{"id":3029,"date":"2021-10-21T16:49:31","date_gmt":"2021-10-21T11:19:31","guid":{"rendered":"https:\/\/binaryterms.com\/?p=3029"},"modified":"2021-10-22T09:59:08","modified_gmt":"2021-10-22T04:29:08","slug":"entity-relationship-diagram","status":"publish","type":"post","link":"https:\/\/binaryterms.com\/entity-relationship-diagram.html","title":{"rendered":"Entity Relationship Diagram (ERD)"},"content":{"rendered":"<p>Entity relationship diagram is the graphical representation associated with the entity relationship model. ER diagram helps in representing the logical structure of the overall database. It represents the relationship between the entity sets stored in the database. The ER diagram illustrate the concepts in a way that is easy for many users to understand how the information system will produce the information.<\/p>\n<h2>Content: Entity Relationship Diagram<\/h2>\n<ol>\n<li><a href=\"#WhatisERDiagram?\">What is ER Diagram?<\/a><\/li>\n<li><a href=\"#UsesofERDiagram\">Uses of ER Diagram<\/a><\/li>\n<li><a href=\"#ComponentsofERDiagram\">Components of ER Diagram<\/a><\/li>\n<li><a href=\"#SymbolsandNotations\">Symbols and Notations<\/a><\/li>\n<li><a href=\"#MappingCardinality\">Mapping Cardinality<\/a><\/li>\n<li><a href=\"#ERDiagramExample\">ER Diagram Example<\/a><\/li>\n<\/ol>\n<p><a name=\"WhatisERDiagram?\"><\/a><\/p>\n<h3>What is ER Diagram?<\/h3>\n<p>ER diagram is designed on the concept of ER model. It provides a graphical representation of entities, attributes and relationships. The ER diagram helps many users even non-technical users to understand the logical structure of the overall database.<br \/>\n<a name=\"UsesofERDiagram\"><\/a><\/p>\n<h3>Uses of Entity Relationship Diagram<\/h3>\n<h4>ER Diagram in DBMS<\/h4>\n<ul>\n<li>The primary use of ER diagrams is to design a database by graphically defining the components of entity relationship model.<\/li>\n<li>ER diagram helps you in identifying the entities, attributes associated with them and the relationship between those entities that are required to design a particular database.<\/li>\n<li>ER diagram also helps you in debugging if there is any flaw or error in the logical structure of the database or if there occurs an error in its deployment.<\/li>\n<\/ul>\n<h3>ER Diagram in Software Engineering<\/h3>\n<p>In software engineering, the ER diagram is used at the initial stages of the planning of software. It helps in identifying the requirements of the information system, the system elements involved and the relationship among them. The ER diagram can also be referred to create a data flow diagram i.e. DFD that explains the workflow of a software.<br \/>\n<a name=\"ComponentsofERDiagram\"><\/a><\/p>\n<h3>Components of ER Diagram<\/h3>\n<p>The three main components of every ER diagram are entities, attributes and relations. These are the building blocks of the ER diagram. Let us talk about each of them:<\/p>\n<p><strong>1. Entity<\/strong><\/p>\n<p>An entity can be described as an object existing in the real world and can be distinguished uniquely from the other objects of the real world. Each entity has a set of properties or attributes for which it has a set of values.<\/p>\n<p>The values of the attributes define the characteristics of that entity that helps in identifying the object uniquely. The entities sharing the same set of attributes are collectively stored in the same entity set.<\/p>\n<p>The entity set can be further classified into two types:<\/p>\n<ul>\n<li><strong>Strong Entity Set: <\/strong>The entity set that is defined by using its own set of attributes can be referred to as a strong entity set.<\/li>\n<li><strong>Weak Entity Set:\u00a0<\/strong>The entity set that cannot be defined by using its own set of attributes that\u2019s why it&#8217;s always associated with another entity set which we refer as an identifier entity set or the owner entity set.<\/li>\n<\/ul>\n<p><strong>2. Attribute<\/strong><\/p>\n<p>Each entity set in the database is defined with some set of attributes that describes the characteristics of each entity of that entity set. The attributes can be further classified into:<\/p>\n<ul>\n<li><strong>Simple and Composite Attributes<\/strong><br \/>\nSimple attributes cannot be further classified such as the <em>id<\/em> attribute of a <em>student<\/em> entity set cannot be further divided into subparts. However, the composite attribute can be classified into sub-parts such as the <em>name<\/em> attribute can be divided into <em>first_name<\/em> and <em>last_name.<\/em><\/li>\n<li><strong>Single-valued and Multivalued Attributes<\/strong><br \/>\nA single-valued attribute accepts a single value such as the <em>id<\/em> attribute of a <em>student<\/em> entity set will accept only one integer value. The multivalued attribute can accept multiple values such as the <em>phone_number<\/em> attribute of a student can have multiple values as a student may have zero, one or many phone numbers.<\/li>\n<li><strong>Derived Attributes<\/strong><br \/>\nThe derived attribute is the attribute whose attribute value can be derived or computed using another attribute\u2019s value. For example, using the <em>date_of_birth<\/em> attribute of the <em>student<\/em> entity set we can compute the value for the age attribute. Although the value of the derived attribute is not stored in the database as it is computed whenever required.<\/li>\n<\/ul>\n<p><strong>3. Relationship<\/strong><\/p>\n<p>Relationship describes the link between the entities to be modelled. For example, the relation between the <em>instructor<\/em> and <em>course<\/em> entity is &#8216;<em>teaches&#8217;<\/em> i.e. the instructor teaches a particular course.<br \/>\n<a name=\"SymbolsandNotations\"><\/a><\/p>\n<h3>Symbols and Notations<\/h3>\n<p>As in the ER diagram we have to represent each component of Er model graphically so there must be some symbols or notation to represent each component. The table below displays some symbols to represent the components of the ER model.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3032\" src=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg\" alt=\"Entity Relationship Diagram Symbols\" width=\"478\" height=\"576\" srcset=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg 478w, https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols-249x300.jpg 249w\" sizes=\"auto, (max-width: 478px) 100vw, 478px\" \/><\/p>\n<ul>\n<li><strong>Rectangles<\/strong> illustrate the entity set.<\/li>\n<li><strong>Diamond<\/strong> illustrates the relationship between the entity set.<\/li>\n<li><strong>Ellipse<\/strong> illustrates the attributes of an entity set.<\/li>\n<li><strong>Lines<\/strong> illustrate the association of attributes to the entity set and the association of entity set to the relationship set.<\/li>\n<\/ul>\n<p><a name=\"MappingCardinality\"><\/a><\/p>\n<h3>Mapping Cardinality<\/h3>\n<p>Mapping cardinality or the cardinality ratio indicates the number of entities of an entity set associated with entities of another entity set by means of a relationship. Consider that we have two participating entity sets A and B then the relationship between the two entity sets can be<\/p>\n<ol>\n<li><strong>One-to-one<\/strong> relationship between two entity sets expresses that one entity from entity set A must be associated to at most one entity of entity set B and vice versa.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3037\" src=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/One-to-One.jpg\" alt=\"One-to-One\" width=\"362\" height=\"72\" srcset=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/One-to-One.jpg 362w, https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/One-to-One-300x60.jpg 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/li>\n<li><strong>One-to-many<\/strong> relationship expresses that one entity from entity set A can be associated with many entities of entity set B and one entity of entity set B can be associated to at most one entity of entity set A.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3036\" src=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/One-to-Many.jpg\" alt=\"One-to-Many\" width=\"359\" height=\"63\" srcset=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/One-to-Many.jpg 359w, https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/One-to-Many-300x53.jpg 300w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/li>\n<li><strong>Many-to-one<\/strong> relationship expresses that one entity from entity set A is associated with one entity of entity set b. But one entity from entity set B may be associated with many entities of the entity set A.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3035\" src=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Many-to-One.jpg\" alt=\"Many-to-One\" width=\"362\" height=\"66\" srcset=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Many-to-One.jpg 362w, https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Many-to-One-300x55.jpg 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/li>\n<li><strong>Many-to-many <\/strong>relationship express that one entity from entity set A can be associated with many entities of entity set B. One entity of entity set B can be associated with many entities of entity set A.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3034\" src=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Many-to-Many.jpg\" alt=\"Many-to-Many\" width=\"362\" height=\"71\" srcset=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Many-to-Many.jpg 362w, https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Many-to-Many-300x59.jpg 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><\/li>\n<\/ol>\n<p><a name=\"ERDiagramExample\"><\/a><\/p>\n<h3>Entity Relationship Diagram Example<\/h3>\n<p>Now learning about the building blocks or components of ER diagram let us draw an ER diagram. Before you initiate drawing the ER diagram you must focus on some basics.<\/p>\n<ul>\n<li>Define the motive and purview of what you are going to model.<\/li>\n<li>Recognize the entity sets that must be considered to model certain databases or information systems. As soon as you identify an entity label it as a noun.<\/li>\n<li>Once you identify the entities involved try to identify the relationship among those entities and label them as verbs.<\/li>\n<li>Next, identify the attributes which will be describing the characteristics of the entities of the entity set.<\/li>\n<li>Map the cardinality between the entities and complete the ER diagram.<\/li>\n<\/ul>\n<p>Now consider a scenario of a bank where a customer comes to withdraw or deposit some amount or to take a loan. So here spontaneously we figure out two basic entity sets involved in the system are the customer and the bank. However, the relationship between the entities customer and bank could be withdrawal, deposit, loan.<\/p>\n<p>The attributes that can describe more about the entity set bank are bank_name, address, branch, affiliation_no. The attributes of the entity set customer are customer_name, account_number, address. The figure below shows you the basic ER diagram of a bank transaction system.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3033\" src=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/ER-Diagram-Example.jpg\" alt=\"ER Diagram- Example\" width=\"600\" height=\"472\" srcset=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/ER-Diagram-Example.jpg 600w, https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/ER-Diagram-Example-300x236.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>So, this is how you can produce an ER diagram. We have learned about the basic components of an ER diagram, we have learned to associate these components with each other to form an ER diagram. We have also studied how these ER diagrams are useful for producing a database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Entity relationship diagram is the graphical representation associated with the entity relationship model. ER diagram helps in representing the logical structure of the overall database. It represents the relationship between the entity sets stored in the database. The ER diagram illustrate the concepts in a way that is easy for many users to understand how [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[4],"tags":[],"class_list":{"0":"post-3029","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dbms","7":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is Entity Relationship Diagram (ERD)? Uses, Components, Symbols &amp; Examples - Binary Terms<\/title>\n<meta name=\"description\" content=\"Entity relationship diagram is the graphical representation associated with the ER Model. that represents the logical structure of the overall database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is Entity Relationship Diagram (ERD)? Uses, Components, Symbols &amp; Examples - Binary Terms\" \/>\n<meta property=\"og:description\" content=\"Entity relationship diagram is the graphical representation associated with the ER Model. that represents the logical structure of the overall database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\" \/>\n<meta property=\"og:site_name\" content=\"Binary Terms\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-21T11:19:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-22T04:29:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg\" \/>\n<meta name=\"author\" content=\"Neha T\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Neha T\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\"},\"author\":{\"name\":\"Neha T\",\"@id\":\"https:\/\/binaryterms.com\/#\/schema\/person\/e495f1d57f5c0a4c521cc3dba95661fe\"},\"headline\":\"Entity Relationship Diagram (ERD)\",\"datePublished\":\"2021-10-21T11:19:31+00:00\",\"dateModified\":\"2021-10-22T04:29:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\"},\"wordCount\":1247,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/binaryterms.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg\",\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\",\"url\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\",\"name\":\"What is Entity Relationship Diagram (ERD)? Uses, Components, Symbols & Examples - Binary Terms\",\"isPartOf\":{\"@id\":\"https:\/\/binaryterms.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage\"},\"image\":{\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg\",\"datePublished\":\"2021-10-21T11:19:31+00:00\",\"dateModified\":\"2021-10-22T04:29:08+00:00\",\"description\":\"Entity relationship diagram is the graphical representation associated with the ER Model. that represents the logical structure of the overall database.\",\"breadcrumb\":{\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/binaryterms.com\/entity-relationship-diagram.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage\",\"url\":\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg\",\"contentUrl\":\"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg\",\"width\":478,\"height\":576,\"caption\":\"Entity Relationship Diagram Symbols\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/binaryterms.com\/entity-relationship-diagram.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/binaryterms.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Entity Relationship Diagram (ERD)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/binaryterms.com\/#website\",\"url\":\"https:\/\/binaryterms.com\/\",\"name\":\"Binary Terms\",\"description\":\"The Computer Science &amp; IT Guide\",\"publisher\":{\"@id\":\"https:\/\/binaryterms.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/binaryterms.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/binaryterms.com\/#organization\",\"name\":\"Binary Terms\",\"url\":\"https:\/\/binaryterms.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/binaryterms.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/binaryterms.com\/wp-content\/uploads\/2020\/05\/binary-terms-logo1.png\",\"contentUrl\":\"https:\/\/binaryterms.com\/wp-content\/uploads\/2020\/05\/binary-terms-logo1.png\",\"width\":400,\"height\":63,\"caption\":\"Binary Terms\"},\"image\":{\"@id\":\"https:\/\/binaryterms.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/binaryterms.com\/#\/schema\/person\/e495f1d57f5c0a4c521cc3dba95661fe\",\"name\":\"Neha T\",\"url\":\"https:\/\/binaryterms.com\/author\/author\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is Entity Relationship Diagram (ERD)? Uses, Components, Symbols & Examples - Binary Terms","description":"Entity relationship diagram is the graphical representation associated with the ER Model. that represents the logical structure of the overall database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/binaryterms.com\/entity-relationship-diagram.html","og_locale":"en_GB","og_type":"article","og_title":"What is Entity Relationship Diagram (ERD)? Uses, Components, Symbols & Examples - Binary Terms","og_description":"Entity relationship diagram is the graphical representation associated with the ER Model. that represents the logical structure of the overall database.","og_url":"https:\/\/binaryterms.com\/entity-relationship-diagram.html","og_site_name":"Binary Terms","article_published_time":"2021-10-21T11:19:31+00:00","article_modified_time":"2021-10-22T04:29:08+00:00","og_image":[{"url":"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg","type":"","width":"","height":""}],"author":"Neha T","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Neha T","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#article","isPartOf":{"@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html"},"author":{"name":"Neha T","@id":"https:\/\/binaryterms.com\/#\/schema\/person\/e495f1d57f5c0a4c521cc3dba95661fe"},"headline":"Entity Relationship Diagram (ERD)","datePublished":"2021-10-21T11:19:31+00:00","dateModified":"2021-10-22T04:29:08+00:00","mainEntityOfPage":{"@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html"},"wordCount":1247,"commentCount":0,"publisher":{"@id":"https:\/\/binaryterms.com\/#organization"},"image":{"@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage"},"thumbnailUrl":"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg","articleSection":["DBMS"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/binaryterms.com\/entity-relationship-diagram.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html","url":"https:\/\/binaryterms.com\/entity-relationship-diagram.html","name":"What is Entity Relationship Diagram (ERD)? Uses, Components, Symbols & Examples - Binary Terms","isPartOf":{"@id":"https:\/\/binaryterms.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage"},"image":{"@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage"},"thumbnailUrl":"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg","datePublished":"2021-10-21T11:19:31+00:00","dateModified":"2021-10-22T04:29:08+00:00","description":"Entity relationship diagram is the graphical representation associated with the ER Model. that represents the logical structure of the overall database.","breadcrumb":{"@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/binaryterms.com\/entity-relationship-diagram.html"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#primaryimage","url":"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg","contentUrl":"https:\/\/binaryterms.com\/wp-content\/uploads\/2021\/10\/Entity-Relationship-Diagram-Symbols.jpg","width":478,"height":576,"caption":"Entity Relationship Diagram Symbols"},{"@type":"BreadcrumbList","@id":"https:\/\/binaryterms.com\/entity-relationship-diagram.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/binaryterms.com\/"},{"@type":"ListItem","position":2,"name":"Entity Relationship Diagram (ERD)"}]},{"@type":"WebSite","@id":"https:\/\/binaryterms.com\/#website","url":"https:\/\/binaryterms.com\/","name":"Binary Terms","description":"The Computer Science &amp; IT Guide","publisher":{"@id":"https:\/\/binaryterms.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/binaryterms.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/binaryterms.com\/#organization","name":"Binary Terms","url":"https:\/\/binaryterms.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/binaryterms.com\/#\/schema\/logo\/image\/","url":"https:\/\/binaryterms.com\/wp-content\/uploads\/2020\/05\/binary-terms-logo1.png","contentUrl":"https:\/\/binaryterms.com\/wp-content\/uploads\/2020\/05\/binary-terms-logo1.png","width":400,"height":63,"caption":"Binary Terms"},"image":{"@id":"https:\/\/binaryterms.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/binaryterms.com\/#\/schema\/person\/e495f1d57f5c0a4c521cc3dba95661fe","name":"Neha T","url":"https:\/\/binaryterms.com\/author\/author"}]}},"_links":{"self":[{"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/posts\/3029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/comments?post=3029"}],"version-history":[{"count":8,"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/posts\/3029\/revisions"}],"predecessor-version":[{"id":3043,"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/posts\/3029\/revisions\/3043"}],"wp:attachment":[{"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/media?parent=3029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/categories?post=3029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/binaryterms.com\/wp-json\/wp\/v2\/tags?post=3029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}