<\/p>\n
A. Lab # : BSBA BIS245A-2<\/p>\n
B. Lab 2 of 7 :Skills Development in Visio; Creation of MS Access Database<\/p>\n
C. Lab Overview\u2014Scenario \/ Summary<\/p>\n
COs:<\/p>\n
1. Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements.<\/p>\n
2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.<\/p>\n
3. Given an existing relational database schema, evaluate and alter the database design for efficiency.<\/p>\n
4. Given an existing database structure demonstrating efficiency and integrity, design the physical tables.<\/p>\n
Scenario:<\/p>\n
You have been asked to create a conceptual database model using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain experience with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a database. You will then modify the model for implementation as a MS Access database. You will create and modify one conceptual model.<\/p>\n
You will then create a MS Access database based on the model developed in Visio, creating the necessary tables and relationships.<\/p>\n
Upon completing this lab, you will be able to<\/p>\n
1. relying on detailed instructions, add two entities to the existing conceptual model (ERD), including attribute data types and required field lengths; <\/p>\n
2. create a new MS Access database file;<\/p>\n
3. using the model from Part A of the lab and relying on detailed instructions; create the first two tables in the database;<\/p>\n
4. use the experience gained in creating the first two tables to add the remaining tables;<\/p>\n
5. using the model from Part A of the lab and relying on detailed instructions; create the relationship between the first two tables in the database; and<\/p>\n
6. use the experience gained in creating the first relationship to create the remaining relationships between the tables<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
A. Lab # : BSBA BIS245A-2 B. Lab 2 of 7 :Skills Development in Visio; Creation of MS Access Database C. Lab Overview\u2014Scenario \/ Summary COs: 1. Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/271832"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=271832"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/271832\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=271832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=271832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=271832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}