{"id":199069,"date":"2018-09-13T19:49:36","date_gmt":"2018-09-13T19:49:36","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/13\/bis-245-week-3-lab-visio-erd-keller-2\/"},"modified":"2018-10-24T09:14:15","modified_gmt":"2018-10-24T09:14:15","slug":"bis-245-week-3-lab-visio-erd-keller-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-245-week-3-lab-visio-erd-keller-2\/","title":{"rendered":"BIS 245 Week 3 Lab &#8211; Visio ERD (Keller)"},"content":{"rendered":"<p>Lab 3 of 7: Database Design Using Visio and Based on Data Requirements and Business Rules<\/p>\n<p>You have been asked to create a database model using MS Visio Database Model Diagram Template.  The purpose of this lab is to provide experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules.<\/p>\n<p>You will then complete an MS Access database based on the model developed in Visio, creating the necessary tables and relationships. <\/p>\n<p>Uponcompletingthislab, youwillbeableto:<\/p>\n<p>create a new Visio file for database design; using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and create a new MS Access database based on the ERD<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Lab 3 of 7: Database Design Using Visio and Based on Data Requirements and Business Rules You have been asked to create a database model using MS Visio Database Model Diagram Template. The purpose of this lab is to provide <a href=\"https:\/\/www.benedictsol.com\/blogs\/bis-245-week-3-lab-visio-erd-keller-2\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-199069","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/199069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=199069"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/199069\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=199069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=199069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=199069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}