Call us 24/7: + 1(925)399 0085

Get your paper done by an expert

No matter what kind of academic paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcer. Save more time for yourself.

WhatsApp + 1(925)399 0085
$ 10
free
  • bibliography
  • title page
  • revisions
per page
19 k happy customers
4.7 out of 5 satisfaction rate
27 writers active

DEVRY BIS245 WEEK 4 iLAB 4

Lab 4a of 7: Database Design Based on Data Requirements and Business Rules Focusing on Interpreting Business Rules to Determine Relationships

iLab 4b of 7: Completing Queries
Note!
Submit your assignment to the Dropbox located on the silver tab at the top of this page.

(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)
Remember This
.devry.edu/”>Connect to the iLab here.

iLAB OVERVIEW

Scenario and Summary

Part A: 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.

Upon completing this lab, you will be able to:
create a new Visio file for database design; and
using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths.

Part B: The lab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. Create a query using the wizard with query-design view or with SQL statements. The Northwind database will be used again in this lab.

Upon completing this lab, you should be able to:
create a query by following lab instruction;
create a query by using either Query Designer or Query Wizard;
create a query by using SQL statements; and
interpret the results of queries.

Deliverables

Part A: Step 6: YourNameLab4A.vsd (Visio Diagram)

Part B: Step 7: YourName_Lab4B_Finital.accdb (Access Database)

iLAB STEPS

A. Lab # : BSBA BIS245A-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 model of the database using a

database modeling tool.

Scenario:

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.

Upon completing this lab, you will be able to

1. create a new Visio file for database design; and

2. using the data requirements and the business rules provided, develop

a conceptual model (ERD), including attribute data types and

required field lengths.

Our guarantees

Study Acers provides students with tutoring and help them save time, and excel in their courses. Students LOVE us!No matter what kind of essay paper you need, it is simple and secure to hire an essay writer for a price you can afford at StudyAcers. Save more time for yourself. Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Our Homework Writing Disciplines

With a highly diverse team in almost all academic fields including: