{"id":3611,"date":"2018-02-28T19:55:33","date_gmt":"2018-03-01T00:55:33","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis5203sec951sp2018\/?page_id=3611"},"modified":"2018-04-05T17:04:10","modified_gmt":"2018-04-05T21:04:10","slug":"322-am-databases","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/322-am-databases\/","title":{"rendered":"3\/22 AM &#8211; Databases"},"content":{"rendered":"<p style=\"padding-left: 30px;\"><span style=\"font-weight: 400;\">\u201c<\/span><span style=\"font-weight: 400;\">Previously, you learned how to represent an organization\u2019s data graphically using an entity-relationship (E-R), or class, diagram. In this unit, you will learn guidelines used to design well-structured and efficient databases, and you will learn about logical and physical database design.\u201d<\/span><\/p>\n<p style=\"padding-left: 30px;\"><span style=\"font-weight: 400;\">Valacich, J. S., &amp; George, J. F. (2017).\u00a0<\/span><i><span style=\"font-weight: 400;\">Modern systems analysis and design <\/span><\/i><span style=\"font-weight: 400;\">(8th ed.). Boston: Pearson.<\/span><\/p>\n<h3>Activities<\/h3>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Read: Chapter 9 in Modern Systems Analysis and Design<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Complete written assignment 11.1 (<a href=\"http:\/\/community.mis.temple.edu\/mis5203sec951sp2018\/files\/2018\/02\/WA-11.1.pdf\">WA-11.1)<\/a><\/span><\/li>\n<li>Complete <a href=\"http:\/\/community.mis.temple.edu\/mis5203sec951sp2018\/pa-10-1-practical-assignment-10\/\">practical assignment 10.1<\/a><\/li>\n<li>Complete written assignment 10.1<\/li>\n<\/ul>\n<h3>Objectives<\/h3>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">describe the database design process, its outcomes, and the relational database model; <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">describe normalization and the rules for second and third normal form; <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">transform an entity-relationship (E-R) diagram into an equivalent set of well-structured (normalized) relations; <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">merge normalized relations from separate user views into a consolidated set of well-structured relations; and <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">describe physical database design concepts including choosing storage formats for fields in database tables, translating well-structured relations into efficient database tables, explaining when to use different types of file organizations to store computer files, and describing the purpose of indexes and the important considerations in selecting attributes to\u00a0be indexed.<\/span><\/li>\n<\/ol>\n<h3>Topics<\/h3>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Database Design<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Normalization<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Database Design from E-R Diagrams<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Merging Relations<\/span><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u201cPreviously, you learned how to represent an organization\u2019s data graphically using an entity-relationship (E-R), or class, diagram. In this unit, you will learn guidelines used to design well-structured and efficient databases, and you will learn about logical and physical database design.\u201d Valacich, J. S., &amp; George, J. F. (2017).\u00a0Modern systems analysis and design (8th ed.). [&hellip;]<\/p>\n","protected":false},"author":17217,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","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":""},"class_list":{"0":"post-3611","1":"page","2":"type-page","3":"status-publish","5":"entry"},"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/pages\/3611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/users\/17217"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/comments?post=3611"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/pages\/3611\/revisions"}],"predecessor-version":[{"id":3658,"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/pages\/3611\/revisions\/3658"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis5205bnai2018\/wp-json\/wp\/v2\/media?parent=3611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}