80 likes | 197 Views
BIS 245 Week 1-7 All Discussion Questions <br>BIS 245 Week 1 Lab 1 Introduction to MS Visio and MS Access <br>BIS 245 Week 2 Lab - Skills Development in Visio<br>BIS 245 Week 3 Lab - Visio ERD <br>BIS 245 Week 4 Lab - ER Diagram <br>BIS 245 Week 5 Lab - ER Diagram and ER Matrix <br>BIS 245 Week 6 iLab Creating Reports<br> BIS 245 Week 7 iLabDevry University<br>
E N D
BIS 245 Academic Achievement/uophelp For more Academic Achievement/uophelps visit www.uophelp.com
BIS 245 Academic Achievement/uophelp BIS 245 Final Exam BIS 245 Week 1 Lab 1 Introduction to MS Visio and MS Access A. Lab # : BSBA BIS 245A-1B. Lab 1 of 7 : Introduction to MS Visio and MS AccessC. Lab Overview--Scenario/Summary TCOs: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. • TCO 1) Which object would you use to enter, delete, or modify data? • (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? • (TCO 1) To design a report you should do all of the following EXCEPT • (TCO 1) Which of the following is NOT a Report Section? • (TCO 1) A Detail line is used to • (TCO 2) For the following image, which of the following is TRUE?
BIS 245 Academic Achievement/uophelp BIS 245 Week 1 BIS 245 Week 2 Lab 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 database, determine, analyze, and classify that information so that reports can be designed to meet the requirements. • Week 1 DQ 1 - Databases and Gathering Requirements • Week 1 DQ 2 - Choosing a Database • Week 2 DQ 1 - Entity Relationship (ER) Modeling • Week 2 DQ 2 - Database Table Design • Week 3 DQ 1 - Conceptual Database Design • Week 3 DQ 2 - Requirements Analysis • Week 4 DQ 1 - Creating Queries from Woodcraft Database
BIS 245 Academic Achievement/uophelp BIS 245 Week 2 BIS 245 Week 3 Lab 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 experience designing, with limited instructions, a simple database based on a list of data requirements and associated business rules. • BIS 245 Week 1 Lab 1 Introduction to MS Visio and MS Access • BIS 245 Week 2 Lab - Skills Development in Visio • BIS 245 Week 3 Lab - Visio ERD • BIS 245 Week 4 Lab - ER Diagram • BIS 245 Week 5 Lab - ER Diagram and ER Matrix • BIS 245 Week 6 iLab Creating Reports • BIS 245 Week 7 iLabDevry University
BIS 245 Academic Achievement/uophelp BIS 245 Week 4 Lab BIS 245 Week 5 Lab A. Lab # : BSBA BIS 245A-5A B. Lab 5A of 7 : Database design using Visio, and based on data requirements and business rules focusing on normalizing data to third normal form. C. Lab Overview--Scenario/Summary: TCO(s): 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. • Page 1 of 5 • A. Lab # : BSBA BIS 245A-4A • B. Lab 4A of 7: Database design based on data requirements and business rules focusing on interpreting business rules to determine relationships. • C. Lab Overview --Scenario/Summary
BIS 245 Academic Achievement/uophelp BIS 245 Week 6 iLab Creating Reports BIS 245 Week 7 iLabDevry University BIS 245 Week 7 iLabDevry University • A. Lab # BSBA BIS 245A-6B. Lab 6 of 7 : Creating ReportsC. Lab Overview – Scenario / Summary: • TCO(s): 7. Given a database application with a completed relational schema, populated tables, and business reporting requirements, create the necessary reports and make a business decision.
BIS 245 Academic Achievement/uophelp BIS 245 Week Entire Course • BIS 245 Week 1-7 All Discussion Questions • BIS 245 Week 1 Lab 1 Introduction to MS Visio and MS Access • BIS 245 Week 2 Lab - Skills Development in Visio • BIS 245 Week 3 Lab - Visio ERD • BIS 245 Week 4 Lab - ER Diagram • BIS 245 Week 5 Lab - ER Diagram and ER Matrix • BIS 245 Week 6 iLab Creating Reports • BIS 245 Week 7 iLabDevry University
BIS 245 Academic Achievement/uophelp For more Academic Achievement/uophelps visit www.uophelp.com