{"id":2426,"date":"2022-05-22T10:23:44","date_gmt":"2022-05-22T14:23:44","guid":{"rendered":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/?p=2426"},"modified":"2022-05-22T10:23:44","modified_gmt":"2022-05-22T14:23:44","slug":"roles-in-an-entity-relationship-diagram","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/2022\/05\/22\/roles-in-an-entity-relationship-diagram\/","title":{"rendered":"Roles in an Entity Relationship Diagram?"},"content":{"rendered":"<p>An Entity Relationship Diagram (ERD) is a type of structural diagram used in database design. An ERD contains entities, attributes, and relationships. The definition of an ERD entity is a definable thing or concept within a system.<\/p>\n<p>This entity can be a person (teacher), object (invoice), concept (profile, or event (transaction). In ER models an entity is shown as a rounded rectangle with the title at top and its attributes listed in the body.\u00a0<\/p>\n<p>An entity attribute is a property or characteristic of the entity that holds it. An attribute has a name that describes the property and a type that describes the type of attribute. An example of attributes below an entity is show below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-2427\" src=\"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/files\/2022\/05\/ERD--300x291.png\" alt=\"\" width=\"192\" height=\"186\" srcset=\"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/files\/2022\/05\/ERD--300x291.png 300w, https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/files\/2022\/05\/ERD-.png 319w\" sizes=\"auto, (max-width: 192px) 100vw, 192px\" \/><\/p>\n<p>A relationship between two entities indicates that the two entities are associated with one another. For example, a customer may order a product. The entity customer is therefore related to the product. This relationship is presented as a connector between them.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An Entity Relationship Diagram (ERD) is a type of structural diagram used in database design. An ERD contains entities, attributes, and relationships. The definition of an ERD entity is a definable thing or concept within a system. This entity can be a person (teacher), object (invoice), concept (profile, or event (transaction). In ER models an [&hellip;]<\/p>\n","protected":false},"author":28304,"featured_media":0,"comment_status":"open","ping_status":"open","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":[663943],"tags":[],"class_list":{"0":"post-2426","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-instructor","7":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/posts\/2426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/users\/28304"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/comments?post=2426"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/posts\/2426\/revisions"}],"predecessor-version":[{"id":2428,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/posts\/2426\/revisions\/2428"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/media?parent=2426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/categories?post=2426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/tags?post=2426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}