{"id":199053,"date":"2018-09-13T19:40:32","date_gmt":"2018-09-13T19:40:32","guid":{"rendered":"http:\/\/localhost\/wordpress\/?p=10"},"modified":"2018-10-24T09:05:21","modified_gmt":"2018-10-24T09:05:21","slug":"bis-245-week-3-lab-visio-erd-keller","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-245-week-3-lab-visio-erd-keller\/","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\/\" 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-199053","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/199053","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=199053"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/199053\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=199053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=199053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=199053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}