80 likes | 121 Views
For more course tutorials visit<br>www.bis245.com<br>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 Course Real Knowledge / bis245dotcom For More Tutorials www.bis245.com
BIS 245 Course Real Knowledge / bis245dotcom BIS 245 Entire Course (Keller) BIS 245 Final Exam (Keller) • 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 • 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
BIS 245 Course Real Knowledge / bis245dotcom BIS 245 Week 1 Lab 1 Introduction to MS Visio and MS Access (Keller) BIS 245 Week 1-7 All Discussion Questions (Keller) • 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
BIS 245 Course Real Knowledge / bis245dotcom BIS 245 Week 1-7 All Labs (Keller) BIS 245 Week 2 Lab - Skills Development in Visio (Keller) • 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 • 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. • 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.
BIS 245 Course Real Knowledge / bis245dotcom BIS 245 Week 3 Lab - Visio ERD (Keller) BIS 245 Week 4 Lab - ER Diagram (Keller) • 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. • 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 Course Real Knowledge / bis245dotcom BIS 245 Week 5 Lab - ER Diagram and ER Matrix (Keller) BIS 245 Week 6 iLab Creating Reports (Keller) • 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. • 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 Course Real Knowledge / bis245dotcom BIS 245 Week 7 iLabDevry University (Keller) • BIS 245 Week 7 iLabDevry University
BIS 245 Course Real Knowledge / bis245dotcom For More Tutorials www.bis245.com