{"id":3000,"date":"2023-01-30T18:15:26","date_gmt":"2023-01-30T23:15:26","guid":{"rendered":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/?p=3000"},"modified":"2023-01-30T18:15:26","modified_gmt":"2023-01-30T23:15:26","slug":"what-is-an-erd-why-is-it-important","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/2023\/01\/30\/what-is-an-erd-why-is-it-important\/","title":{"rendered":"What is an ERD? Why is it Important?"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/www.guru99.com\/images\/1\/100518_0621_ERDiagramTu1.png\" alt=\"Entity Relationship (ER) Diagram Model with DBMS Example\" width=\"228\" height=\"222\" \/>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/wcs.smartdraw.com\/entity-relationship-diagram\/img\/traditional-erd-example.png?bn=15100111862\" alt=\"Entity Relationship Diagram (ERD) - What is an ER Diagram?\" width=\"336\" height=\"215\" \/><\/p>\n<p><span style=\"font-weight: 400\">ERDs are a very useful tool for database creation. First, let\u2019s dive into some background information about the diagrams. ERD stands for entity relationship diagram and is a data model visually representing the relationship between entities. There are two notations for ERDs, one being Chen\u2019s database notation. This version consists of symbols representing the different components of an ERD. The entities are rectangles, the attributes are circles, and the relationships are diamonds. The other notation is Crow\u2019s foot. This version has tables with the entity at the top, attributes listed below, and arrows connecting the tables to represent the relationships. So, why are ERDs so important? Why should we care about learning how to create and interpret them?\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">The entity relationship diagram provides a visual representation of a starting point for database design. It is an organized way to map out key information involving the database that is being created. So, when reviewing components of the database, it is easy to see what worked and what needs to be improved on. It is also easy to add said improvements. Then, since this information is saved into a diagram, creators can refer to it at any point in time, especially when working on other projects. I believe that learning how to create these organized visual diagrams is a useful tool, hence why it\u2019s important to understand the ins and outs of the ERD.\u00a0<\/span><\/p>\n<p>Chen&#8217;s database image link: https:\/\/www.smartdraw.com\/entity-relationship-diagram\/<\/p>\n<p>Crow&#8217;s foot database image link: https:\/\/www.guru99.com\/er-diagram-tutorial-dbms.html<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 ERDs are a very useful tool for database creation. First, let\u2019s dive into some background information about the diagrams. ERD stands for entity relationship diagram and is a data model visually representing the relationship between entities. There are two notations for ERDs, one being [&hellip;]<\/p>\n","protected":false},"author":29427,"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":[845065,7088,178,669510],"class_list":{"0":"post-3000","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-student-post","7":"tag-benefit","8":"tag-erd","9":"tag-mis","10":"tag-system","11":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts\/3000","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\/29427"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/comments?post=3000"}],"version-history":[{"count":2,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts\/3000\/revisions"}],"predecessor-version":[{"id":3002,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/posts\/3000\/revisions\/3002"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/media?parent=3000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/categories?post=3000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec730spring2023\/wp-json\/wp\/v2\/tags?post=3000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}