{"id":203055,"date":"2018-09-13T23:18:39","date_gmt":"2018-09-13T23:18:39","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/13\/bis-245-week-3-lab-visio-erd\/"},"modified":"2018-10-24T08:57:36","modified_gmt":"2018-10-24T08:57:36","slug":"bis-245-week-3-lab-visio-erd","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/bis-245-week-3-lab-visio-erd\/","title":{"rendered":"BIS 245 Week 3 Lab &#8211; Visio ERD"},"content":{"rendered":"<p>Lab\u00a03 of 7: Database Design Using Visio and Based on Data Requirements and Business Rules\tYou have been asked to create a database model using MS Visio Database Model Diagram Template.\u00a0 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.\tYou will then complete an MS Access database based on the model developed in Visio, creating the necessary tables and relationships.\u00a0\t\u00a0\tUponcompletingthislab, youwillbeableto:\tcreate 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\u00a03 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.\u00a0 The purpose of this lab is to provide experience <a href=\"https:\/\/www.benedictsol.com\/blogs\/bis-245-week-3-lab-visio-erd\/\" 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-203055","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203055","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=203055"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203055\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}