Week 4 iLab for evagat

Scenario/Summary

-

Week 4 Assignments

Part A:

You have been a

sked to create a database model using MS Visio Database

Model Diagram Template. The purpose of this iLab is to provide experience designing,

with limited instructions, a simple database based on a list of data requirements and

associated business rules.

Up

on completing this iLab, 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 iLab 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 statemen

ts. The Northwind (NWind) database will be used again in this iLab.

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 stat

ements; and

·

interpret the results of queries.

Software Citation Requirements

This course uses open

-

source software, which must be cited when used for any student

work. Citation requirements are on the

Open Source Applications

page.

Please review the

installation instruction files

to complete your assignment.

Listen

Deliverables

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions

on how to use the Dropbox, read these

step

-

by

-

step instructions

.

(See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)

Part A:

YourNameLab4A.vsdx (Visio Diagram)

Part B:

YourName_Lab4B_Finital.accdb (Access Database)

Scenario/Summary-Week 4 Assignments

Part A: You have been asked to create a database model using MS Visio Database

Model Diagram Template. The purpose of this iLab 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 iLab, 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 iLab 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 (NWind) database will be used again in this iLab.

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.

Software Citation Requirements

This course uses open-source software, which must be cited when used for any student

work. Citation requirements are on the Open Source Applications page.

Please review the installation instruction files to complete your assignment.

Listen

Deliverables

NOTE

Submit your assignment to the Dropbox, located at the top of this page. For instructions

on how to use the Dropbox, read these step-by-step instructions.

(See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)

Part A: YourNameLab4A.vsdx (Visio Diagram)

Part B: YourName_Lab4B_Finital.accdb (Access Database)