BIS 245 Course Experience Tradition / bis245.com

1
BIS 245 Course Experience Tradition / bis245.com
For More Courses
Visit Now
www.bis245.com
The progress of the world depends almost entirely
upon education
2
BIS 245 Course Experience Tradition / bis245.com
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 iLabDevry
University
3
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Final Exam (Keller)
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
4
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 1 Lab 1 Introduction to MS Visio and
MS Access (Keller)
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.
5
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 1-7 All Discussion Questions (Keller)
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
6
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 1-7 All Labs (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 BIS 245 Week 6 iLab
Creating Reports BIS 245 Week 7 iLabDevry
University
7
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 2 Lab - Skills Development in Visio
(Keller)
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.
8
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 3 Lab - Visio ERD (Keller)
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.
9
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 4 Lab - ER Diagram (Keller)
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.
10
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 5 Lab - ER Diagram and ER Matrix
(Keller)
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.
11
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 6 iLab Creating Reports (Keller)
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.
12
BIS 245 Course Experience Tradition / bis245.com
BIS 245 Week 7 iLabDevry University (Keller)
BIS 245 Week 7 iLabDevry University
13
BIS 245 Course Experience Tradition / bis245.com
For More Courses
Visit Now
www.bis245.com
The progress of the world depends almost entirely
upon education