{"id":2276,"date":"2020-10-29T16:00:47","date_gmt":"2020-10-29T16:00:47","guid":{"rendered":"http:\/\/onlineclassesguru.com\/?p=2276"},"modified":"2020-10-29T16:00:47","modified_gmt":"2020-10-29T16:00:47","slug":"an-er-diagram","status":"publish","type":"post","link":"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/","title":{"rendered":"an ER Diagram"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">Create and submit an ER Diagram with at least two tables and their attributes. \u00a0Your diagram should include:<\/p>\n<ul style=\"box-sizing: border-box; list-style: none; padding: 0px; margin: 0px; color: #001847; font-family: Arimo, sans-serif; font-size: 24px;\">\n<li style=\"box-sizing: border-box;\">Table Names (for each entity)<\/li>\n<li style=\"box-sizing: border-box;\">Attributes (first name, last name, city, etc.)<\/li>\n<li style=\"box-sizing: border-box;\">Primary Keys<\/li>\n<li style=\"box-sizing: border-box;\">Foreign keys<\/li>\n<li style=\"box-sizing: border-box;\">Relationships<\/li>\n<li style=\"box-sizing: border-box;\">Field types\u00a0\u00a0(text, currency, numeric, date)<\/li>\n<\/ul>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">Your tables should be should be normalized (first, second and third normal forms)<\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">\u00a0 You can use the attached form or upload your tables in Excel or create and link them in an Access database file.<\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">For information on how to use Word to create and ERD, go to:\u00a0<a style=\"box-sizing: border-box; text-decoration-line: none; cursor: pointer;\" href=\"https:\/\/vimeo.com\/18244802\" rel=\"nofollow\">https:\/\/vimeo.com\/18244802<\/a><\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">Resources for Building ER Diagrams and Normalization:<\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">What is an ER Diagram:\u00a0<a style=\"box-sizing: border-box; text-decoration-line: none; cursor: pointer;\" href=\"http:\/\/databases.about.com\/od\/specificproducts\/l\/blentity-relationship-diagrams.htm\" rel=\"nofollow\">http:\/\/databases.about.com\/od\/specificproducts\/l\/blentity-relationship-diagrams.htm<\/a><\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">Video Tutorial\u00a0Entity Relationship Diagram (ERD) Training Video: \u00a0<a style=\"box-sizing: border-box; text-decoration-line: none; cursor: pointer;\" href=\"https:\/\/www.youtube.com\/watch?v=-fQ-bRllhXc\" rel=\"nofollow\">https:\/\/www.youtube.com\/watch?v=-fQ-bRllhXc<\/a><\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px; font-size: 24px; color: #001847; font-family: Arimo, sans-serif;\">How do I normalize a database:\u00a0<a style=\"box-sizing: border-box; text-decoration-line: none; color: #7429ff; cursor: pointer;\" title=\"Click to open in a new window or tab\nhttps:\/\/support.microsoft.com\/EN-US\/help\/283878\" href=\"https:\/\/support.microsoft.com\/EN-US\/help\/283878\" rel=\"nofollow\">https:\/\/support.microsoft.com\/EN-US\/help\/283878<\/a><\/p>\n<p><center><a href=\"http:\/\/onlineclassesguru.com\/orders\/ordernow\"><img decoding=\"async\" src=\"https:\/\/encrypted-tbn0.gstatic.com\/images?q=tbn:ANd9GcTyj99p60XCLyLk1htB7-1neRt8-2QdnenNlQ&usqp=CAU\"target=\"_http:\/\/onlineclassesguru.com\/orders\/ordernow\"\/><\/center><p>","protected":false},"excerpt":{"rendered":"<p>Create and submit an ER Diagram with at least two tables and their attributes. \u00a0Your diagram should include: Table Names (for each entity) Attributes (first name, last name, city, etc.) Primary Keys Foreign keys Relationships Field types\u00a0\u00a0(text, currency, numeric, date) Your tables should be should be normalized (first, second and third normal forms) \u00a0 You&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2276","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>an ER Diagram - onlineclassesguru<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"an ER Diagram - onlineclassesguru\" \/>\n<meta property=\"og:description\" content=\"Create and submit an ER Diagram with at least two tables and their attributes. \u00a0Your diagram should include: Table Names (for each entity) Attributes (first name, last name, city, etc.) Primary Keys Foreign keys Relationships Field types\u00a0\u00a0(text, currency, numeric, date) Your tables should be should be normalized (first, second and third normal forms) \u00a0 You...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/\" \/>\n<meta property=\"og:site_name\" content=\"onlineclassesguru\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-29T16:00:47+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin_admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineclassesguru.com\/#website\",\"url\":\"https:\/\/onlineclassesguru.com\/\",\"name\":\"onlineclassesguru\",\"description\":\"Cheap Professional coursework and reaction papers help\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineclassesguru.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/#webpage\",\"url\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/\",\"name\":\"an ER Diagram - onlineclassesguru\",\"isPartOf\":{\"@id\":\"https:\/\/onlineclassesguru.com\/#website\"},\"datePublished\":\"2020-10-29T16:00:47+00:00\",\"dateModified\":\"2020-10-29T16:00:47+00:00\",\"author\":{\"@id\":\"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineclassesguru.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"an ER Diagram\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742\",\"name\":\"admin_admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/onlineclassesguru.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g\",\"caption\":\"admin_admin\"},\"url\":\"https:\/\/onlineclassesguru.com\/index.php\/author\/admin_admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"an ER Diagram - onlineclassesguru","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:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/","og_locale":"en_US","og_type":"article","og_title":"an ER Diagram - onlineclassesguru","og_description":"Create and submit an ER Diagram with at least two tables and their attributes. \u00a0Your diagram should include: Table Names (for each entity) Attributes (first name, last name, city, etc.) Primary Keys Foreign keys Relationships Field types\u00a0\u00a0(text, currency, numeric, date) Your tables should be should be normalized (first, second and third normal forms) \u00a0 You...","og_url":"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/","og_site_name":"onlineclassesguru","article_published_time":"2020-10-29T16:00:47+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin_admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/onlineclassesguru.com\/#website","url":"https:\/\/onlineclassesguru.com\/","name":"onlineclassesguru","description":"Cheap Professional coursework and reaction papers help","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineclassesguru.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/#webpage","url":"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/","name":"an ER Diagram - onlineclassesguru","isPartOf":{"@id":"https:\/\/onlineclassesguru.com\/#website"},"datePublished":"2020-10-29T16:00:47+00:00","dateModified":"2020-10-29T16:00:47+00:00","author":{"@id":"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742"},"breadcrumb":{"@id":"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineclassesguru.com\/index.php\/2020\/10\/29\/an-er-diagram\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineclassesguru.com\/"},{"@type":"ListItem","position":2,"name":"an ER Diagram"}]},{"@type":"Person","@id":"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742","name":"admin_admin","image":{"@type":"ImageObject","@id":"https:\/\/onlineclassesguru.com\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g","caption":"admin_admin"},"url":"https:\/\/onlineclassesguru.com\/index.php\/author\/admin_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts\/2276"}],"collection":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/comments?post=2276"}],"version-history":[{"count":2,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts\/2276\/revisions"}],"predecessor-version":[{"id":2278,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts\/2276\/revisions\/2278"}],"wp:attachment":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/media?parent=2276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/categories?post=2276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/tags?post=2276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}