A. Lab # : BSBA BIS 245A-2<\/p>\n
B. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database<\/p>\n
C. Lab Overview–Scenario \/ Summary:<\/p>\n
TCOs:<\/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 Parts A and B 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 Parts A and B 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","protected":false},"excerpt":{"rendered":"
A. Lab # : BSBA BIS 245A-2 B. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database C. Lab Overview–Scenario \/ Summary: TCOs: 1. Given a business situation in which managers require information from a Read More …<\/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-199068","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/199068","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=199068"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/199068\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=199068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=199068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=199068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}