BIS 245 Database Essentials for Business with Lab

BIS 245 WEEK 6 LAB A Lab BSBA BIS 245A6 B Lab 6 of 7 Creating Reports C. 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 wa

10 Other / Other Devry University / BIS 245 30 Sep 2015

BIS 245 WEEK 5 LAB A Lab BSBA BIS245A 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. Scenario: You have been asked to create a database model

10 Other / Other Devry University / BIS 245 30 Sep 2015

BIS 245 WEEK 5 LAB A Lab BSBA BIS245A 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. Scenario: You have been asked to create a database mod

10 Other / Other Devry University / BIS 245 30 Sep 2015

BIS 245 WEEK 6 DISCUSSION II Reports and Data Gathering Discussion Presenting Data Effectively (graded) Data presentation should be designed to display correct conclusions. What issues should we think about as we prepare data for presentation? Discuss the different methods that we can use to present data in a report. What role does the audience play in selecting how we present the data?

3 Other / Other Devry University / BIS 245 15 Oct 2015

BIS 245 WEEK 5 DISCUSSION II Forms Normalization and Validation Discussion Data Validation (graded) What is the importance of data validation? How can we avoid data-entry errors? How can forms help us reduce data-entry errors? What features does Access offer to help validate data? What are the different kinds of validations that are required?

3 Other / Other Devry University / BIS 245 15 Oct 2015

BIS 245 WEEK 4 DISCUSSION II Queries SQL and Views Discussion Creating Queries from North wind Database (graded) In Doc Sharing, you will find an Access database labeled Week 4 Discussion North wind. Save the database to your computer and open the database using Access. Answer the questions below. Please assist one another. a. View the design of the database in the Database Tools-Relationships window. Describe some queries that would

3 Other / Other Devry University / BIS 245 15 Oct 2015

BIS 245 WEEK 3 DISCUSSION II Tables MS Access vs Excel and Data Integrity Discussion Requirements Analysis (graded) Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.

3 Other / Other Devry University / BIS 245 15 Oct 2015

BIS 245 Week 1 DISCUSSION I Roles of Databases MS Access Familiarity and Requirements Gathering Discussion Databases and Gathering Requirements (graded) 1. Why are databases important to business? How do databases generate sales and-or profits? What databases do you interact with, and how do they benefit you? 2. What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before

3 Other / Other Devry University / BIS 245 15 Oct 2015