{"id":3683,"date":"2019-11-08T07:42:55","date_gmt":"2019-11-08T12:42:55","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/?p=3683"},"modified":"2019-11-08T07:42:55","modified_gmt":"2019-11-08T12:42:55","slug":"database-architecture-and-development","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/2019\/11\/08\/database-architecture-and-development\/","title":{"rendered":"Database Architecture and Development"},"content":{"rendered":"<p>Why do we store data in separate tables and not in one big table?\u00a0\u00a0Explain to me how we take an ERD and translate boxes and lines in the ERD into a SQL statement.\u00a0 \u00a0 What is needed in order to design an ERD? What is needed to work with multiple tables in a SQL statement?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Why do we store data in separate tables and not in one big table?\u00a0\u00a0Explain to me how we take an ERD and translate boxes and lines in the ERD into a SQL statement.\u00a0 \u00a0 What is needed in order to design an ERD? What is needed to work with multiple tables in a SQL statement?<\/p>\n","protected":false},"author":12705,"featured_media":0,"comment_status":"open","ping_status":"closed","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":[476038],"tags":[],"class_list":{"0":"post-3683","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-class-discussion","7":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/posts\/3683","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/users\/12705"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/comments?post=3683"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/posts\/3683\/revisions"}],"predecessor-version":[{"id":3684,"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/posts\/3683\/revisions\/3684"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/media?parent=3683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/categories?post=3683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5122sec002fall2019\/wp-json\/wp\/v2\/tags?post=3683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}