{"id":2637,"date":"2022-06-18T13:00:50","date_gmt":"2022-06-18T17:00:50","guid":{"rendered":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/?p=2637"},"modified":"2022-06-18T13:00:50","modified_gmt":"2022-06-18T17:00:50","slug":"questions-3","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/2022\/06\/18\/questions-3\/","title":{"rendered":"Questions: 3"},"content":{"rendered":"<p>An ERD (Entity Relationship Diagram) is a visual representation of different data using conventions that describe how these data are related to one another. It is made up of an entity (noun), attribute (adjective), and relationship (verb). A rectangle symbolizes an entity, an oval symbolizes an attribute, and a diamond represents a relationship. There are two different notations for ERD&#8217;s: Chen&#8217;s Database Notation and Crow&#8217;s Foot Database Notation. The main difference between these ERD&#8217;s is that Chen database notation uses a diamond and connecting lines with symbols to describe relationship and cardinality, while Crow&#8217;s Foot database notation just uses lines with symbols on the end.\u00a0Cardinality is essential for showing the numerical relationship between entities. Cardinality also describes a fundamental relationship between two entities or objects. There are three relationship types or cardinalities:<span class=\"Apple-converted-space\">\u00a0<\/span>one-to-one, <span role=\"tooltip\"><span class=\"povykd\" role=\"button\" data-enable-toggle-animation=\"true\" data-extra-container-classes=\"ZLo7Eb\" data-hover-hide-delay=\"1000\" data-hover-open-delay=\"500\" data-send-open-event=\"true\" data-theme=\"0\" data-width=\"250\" data-ved=\"2ahUKEwjGmJHou7f4AhU8j4kEHcnoCxUQmpgGegQIGxAD\"><span class=\"JPfdse\" data-bubble-link=\"\" data-segment-text=\"one-to-many\">one-to-many<\/span><\/span>, and many-to-many<\/span>.<span class=\"Apple-converted-space\">\u00a0These\u00a0cardinality are\u00a0differentiated by different symbols.\u00a0<\/span><span role=\"tooltip\"><span class=\"povykd\" role=\"button\" data-enable-toggle-animation=\"true\" data-extra-container-classes=\"ZLo7Eb\" data-hover-hide-delay=\"1000\" data-hover-open-delay=\"500\" data-send-open-event=\"true\" data-theme=\"0\" data-width=\"250\" data-ved=\"2ahUKEwjGmJHou7f4AhU8j4kEHcnoCxUQmpgGegQIGxAI\"><span class=\"JPfdse\" data-bubble-link=\"\" data-segment-text=\"Entity-Relationship\">Entity-Relationship<\/span><\/span> (ER) diagrams are used to describe the cardinality in databases.\u00a0<\/span>The relationship&#8217;s within Crow&#8217;s foot notation is a straight line connecting multiplicity of one and a mandatory relationship. The key idea behind a ERD is to\u00a0help to identify different system elements and their relationships with each other. Another aspect that I previously described in Week 2 is Salesforce.<span style=\"font-size: 12pt\"> Salesforce is a cloud-based software company that provides customer relationship management software and applications. Within Salesforce, there are dynamic dashboards. Dynamic dashboards enable each user to see the data they have access to. With a dynamic dashboard, you can control data visibility without having to create a separate dashboard, with its own running user and folder, for each level of data access(Salesforce.com).\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"n3VNCb KAlRDb\" src=\"https:\/\/www.softwebsolutions.com\/wp-content\/uploads\/2021\/03\/salesforce-eco-system.jpg\" alt=\"Why Salesforce ecosystem is a complete platform for customer success\" width=\"458\" height=\"291\" data-noaft=\"1\" \/><img loading=\"lazy\" decoding=\"async\" class=\"n3VNCb KAlRDb\" src=\"https:\/\/www.conceptdraw.com\/How-To-Guide\/picture\/crows-foot-erd.png\" alt=\"How To Make a Crow's Foot ER Diagram | Design Element: Crows Foot for Entity  Relationship Diagram - ERD | Entity Relationship Diagram - ERD - Software  for Design Crows Foot ER Diagrams | Crows Foot Diagram\" width=\"538\" height=\"342\" data-noaft=\"1\" \/><img loading=\"lazy\" decoding=\"async\" class=\"n3VNCb KAlRDb\" src=\"https:\/\/www.conceptdraw.com\/How-To-Guide\/picture\/chen-erd.png\" alt=\"How To Make Chen ER Diagram | Entity Relationship Diagram - ERD - Software  for Design Chen ER Diagrams | ERD Symbols and Meanings | What Is Chen  Notation\" width=\"468\" height=\"426\" data-noaft=\"1\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>An ERD (Entity Relationship Diagram) is a visual representation of different data using conventions that describe how these data are related to one another. It is made up of an entity (noun), attribute (adjective), and relationship (verb). A rectangle symbolizes an entity, an oval symbolizes an attribute, and a diamond represents a relationship. There are [&hellip;]<\/p>\n","protected":false},"author":28310,"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-2637","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\/2637","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\/28310"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/comments?post=2637"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/posts\/2637\/revisions"}],"predecessor-version":[{"id":2638,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/posts\/2637\/revisions\/2638"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/media?parent=2637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/categories?post=2637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2101sec712summer2022\/wp-json\/wp\/v2\/tags?post=2637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}