BIS 245 Academic professor/tutorialrank.com

1
BIS 245 Academic professor/tutorialrank.com
For more course Tutorials
www.tutorialrank.com
2
BIS 245 Academic professor/tutorialrank.com
BIS 245 Final Exam
BIS 245 Entire Course (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 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 iLab Devry
University
(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? (TCO 2) A symbol used in ER
diagrams for an entity is a (TCO 3) A property
that provides a "user friendly" name to a column
in Datasheet View is a (TCO 3) Summarized data
in an easy-to-read view is known as a
3
BIS 245 Academic professor/tutorialrank.com
BIS 245 Week 1-7 All Discussion Questions
BIS 245 Week 1 Lab 1 Introduction to MS Visio and
MS
A. Lab BSBA BIS 245A-1B. Lab 1 of 7
Introduction to MS Visio and MS AccessC. Lab
Overview--Scenario/Summary TCOs1. 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.
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 Week 4
DQ 2 - Creating Queries from Northwind Database
Week 5 DQ 1 - Data Normalization Week 5 DQ 2 -
Data Validation
4
BIS 245 Academic professor/tutorialrank.com
BIS 245 Week 2 Lab - Skills Development in Visio
BIS 245 Week 1-7 All Labs and DQs
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
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. 2. Given a situation
containing entities, business rules, and data
requirements, create the conceptual model of the
database using a database modeling tool.
5
BIS 245 Academic professor/tutorialrank.com
BIS 245 Week 4 Lab - ER Diagram
BIS 245 Week 3 Lab - Visio ERD
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. You will then complete
an MS Access database based on the model
developed in Visio, creating the necessary tables
and relationships. 
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  TCO(s)  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
6
BIS 245 Academic professor/tutorialrank.com
BIS 245 Week 6 iLab Creating Reports
BIS 245 Week 5 Lab - ER Diagram and ER Matrix
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
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. Scenario The purpose of this lab is to
create Access Reports. After a report is created,
the student will sort the fields in different
ways. Also the Student can also delete fields in
layout view and modify the appearance of the
report by applying Themes. In addition to the
report
7
BIS 245 Academic professor/tutorialrank.com
BIS 245 Week 7 iLabDevry University
BIS 245 Week 7 iLabDevry University
8
BIS 245 Academic professor/tutorialrank.com
For more course Tutorials
www.tutorialrank.com