An entity relationship diagram, or ERD, is a visual representation of data that also shows how that data is connected. Just like with swim lane diagrams, symbols make it much easier to differentiate the various pieces of data and their relation to others. A rectangle is for an entity, which can be filled in with a noun such as “shopper”. An oval is for the attribute (such as “item price”) and is characterized by an adjective. Lastly, a diamond shows a relationship between two entities and will be characterized by a verb (such as “purchases”). When writing ERD tables, the layout is slightly different, so there are a few things to keep in mind. The entity is written at the top of the table (order, for example), and underneath is where the entity’s attributes are written (item, quantity, etc.). In addition, the relationship\/verb is written on the arrow connecting the two entities. Although it may seem like a lot of information, ERDs are pretty simple when you break them down. Overall, they are great for painting a picture of what exactly is going on in a chaotic business environment.<\/p>\n","protected":false},"excerpt":{"rendered":"
An entity relationship diagram, or ERD, is a visual representation of data that also shows how that data is connected. Just like with swim lane diagrams, symbols make it much easier to differentiate the various pieces of data and their relation to others. A rectangle is for an entity, which can be filled in with […]<\/p>\n","protected":false},"author":29446,"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":[10531],"tags":[845089,7088],"class_list":["post-3499","post","type-post","status-publish","format-standard","category-student-post","tag-entity-relationship-diagram","tag-erd","entry"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts\/3499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/users\/29446"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/comments?post=3499"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts\/3499\/revisions"}],"predecessor-version":[{"id":3500,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts\/3499\/revisions\/3500"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/media?parent=3499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/categories?post=3499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/tags?post=3499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}