CIS 336 DeVry All Week I Labs

admin   June 29, 2017   Comments Off on CIS 336 DeVry All Week I Labs

CIS 336 DeVry All Week I Labs

Downloading is very simple, you can download this Course here:

http://wiseamerican.us/product/cis-336-devry-week-ilabs/

Or

Contact us at:

SUPPORT@WISEAMERICAN.US

CIS 336 DeVry All Week iLabs

CIS336

CIS 336 DeVry Week 1 iLab Latest

.equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336_W1_iLab.html”>iLab> Required Software

Lab 1 of 7: Normal Forms and Entity Relationship Diagrams

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using Read Speaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Download the iLab instructions and the Answer Sheet for the necessary steps to be completed for this lab. They can be found below. You will notice that the readings, including lectures, the examples we worked on during the lecture, and other audio and visual aids provided, will help you tackle this week’s lab. Remember to always follow the instructions to get maximum credit, and use the weekly discussion related to the iLab and the Q & A Forum for additional help. Be specific and state the problem you are having clearly, including what you have done to resolve it, in the discussion.

Microsoft Visio Tutorial—Important Information

Important: Before starting, be sure to review the Logical Modeling Part 1video under Video Library to familiarize you with how to use MS Visio to draw Entity Relationship Diagrams.

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.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab is a single MS Word document named lab1_solutions_yourname.docx with the answers included for Steps 1–4.

Required Software

Microsoft Office: Word and Visio 2010

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu.

Lab Steps

STEP 1: Download the Week 1 Lab Instructions

Follow the instructions to complete the lab by downloading the following files: · .equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336Lab1_Instructions.docx”>CIS336Lab1_Instructions.docx ·

.equella.ecollege.com/file/4c59b998-a778-4673-b5b5-1040a4a59543/17/CIS336Lab1_StudentAnswerSheet.docx”>CIS336Lab1_StudentAnswerSheet.docx

STEP 2: Submit Your Answers on the Lab 1 Student Answer Sheet

Use Visio or Word to draw the dependency diagrams for Steps 1–3. Use Visio to draw the ERD for Step 4. This is the end of iLab #1

 

CIS 336 DeVry Week 2 iLab Latest

.equella.ecollege.com/file/ace06cf1-3107-42f4-9c63-b71dc0625d56/15/CIS336_W2_iLab.html”>iLab> Lab Steps

Lab 2 of 7: The Expanded Entity Relationship Diagram

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Download the iLab instructions and the Answer Sheet for the necessary steps to be completed for this lab. They can be found below. You will notice that the readings, including lectures, the examples we worked on during the lecture, and other audio and visual aids provided, will help you tackle this week’s lab. Remember to always follow the instructions to get maximum credit, and use the weekly discussion related to the iLab and the Q & A Forum for additional help. Be specific and state the problem you are having clearly, including what you have done to resolve it, in the discussion.

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.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will be your completed ERD as a single MS Word document using copy/paste from the MS Visio application and namedlab2_solutions_yourname.docx

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

Lab Steps

STEP 1: Download the Week 2 Lab Instructions.

Follow the instructions to complete the lab by downloading the following files: ·.equella.ecollege.com/file/ace06cf1-3107-42f4-9c63-b71dc0625d56/15/CIS336Lab2_Instructions.docx”>CIS336Lab2_Instructions.docx

STEP 2: Submit Your Answers

Use Visio to create your ERD. Copy and paste to a Word document as indicated in the lab instructions. This is the end of lab #2

 

CIS 336 DeVry Week 3 iLab Latest

.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336_W3_iLab.html”>iLab> Lab Steps

Lab 3 of 7: Building the Physical Model

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Beginning with this lab, and continuing through the remaining weeks you will be doing all of your work in the MySQL EDUPE Environment. By now you have received your logon ID and password and should have at least made sure you can connect. If for any reason you have not done so, please do so now before continuing any further. If for any reason you cannot connect, then you need to let the instructor know ASAP so that any problems can be resolved.

In this lab you will transform a logical database design (data model) into a physical model (tables, constraints, and relationships). Your job will be to take the relationship diagram along with the meta data defined in the data dictionary and define the table structures and constraints to create the physical tables. Once this has been done, you will populate the tables with data. Lastly, you will write SELECT statements to query the tables and verify the data was populated.

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.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

  1. Your script file. Create this file in Notepad, not Word. Make sure your name is in a comment area at the top of the script file. Use a double dash to create a one-line comment.

—Jacob Smith

—Lab 3

Required Software

MySQL

Access the software at.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

STEP 1: Download the Week 3 Lab Instructions

Complete the lab by downloading the following files this week: ·

.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336Lab3_Instructions.docx”>CIS336Lab3_Instructions.docx

.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336Lab3_Files.zip”>CIS336Lab3_Files.zip

STEP 2: Submit Your SQL Command File

Use Notepad to write the SQL statements and submit according the lab instructions.

This is the end of Lab #3

 

 

CIS 336 DeVry Week 4 iLab Latest

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336_W4_iLab.html”>iLab> STEP 2: Download the Week 4 Lab Instructions and Answer Sheet

Lab 4 of 7: Building the Physical Model

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Lab 4 will introduce the various aspects of the SQL SELECT statement and the methods of retrieving data from the database tables. The lab will utilize a database with a set of tables that you will create and populate using the instructions and script file found below. These tables will be used for the remaining labs in this class.

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

.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions.

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

The deliverable for this lab will include the following.

The Student Answer Sheet file below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 4.

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

MySQL Access the software at

.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

STEP 1: Create the Database and Tables

Create the database and tables (that will be used in labs 4–7) by downloading the following files.

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CreateOMTables.docx”>CreateOMTables.docx(Instructions)

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql”>create_OM_db.sql(Database Script)

STEP 2: Download the Week 4 Lab Instructions and Answer Sheet

Follow the instructions to complete the lab by downloading the following files.

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336Lab4_Instructions.docx”>CIS336Lab4_Instructions.docx

.equella.ecollege.com/file/184903ef-b6c7-433c-89e6-d48b5ad6f3be/27/CIS336Lab4_StudentAnswerSheet.docx”>CIS336Lab4_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docxwhen creating your queries.

STEP 3: Submit Your Answer sheet

Complete the Answer Sheet to show your queries and results and submit according to the lab instructions.

This is the end of Lab#4.

 

 

CIS 336 DeVry Week 5 iLab Latest

.equella.ecollege.com/file/67acd265-3032-4b50-850b-b98f6d50c25b/24/CIS336_W5_iLab.html”>iLab> STEP 1: Download the Week 5 Lab Instructions and Answer Sheet

Lab 5 of 7: Retrieving Data From Multiple Tables (39 points)

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Lab 5 deals with writing queries using multiple tables as covered in the reading and lecture material this week. In some cases, you will be given the option to choose the JOIN syntax to use, in other cases, you will be asked to take a specific approach. Using the incorrect process when the process is specified will result in points being taken off for that problem.

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.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will include:

The Student Answer Sheet file that you will download below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 5.

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

MySQL

Access the software at.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

PRELIMINARY STEP: If You Have Not Created the Database Yet, Please Complete.

This lab will utilize the tables that were created in Lab 4. If you have not yet created these tables,you can create the database and tables (used in labs 4–7) by downloading the following files.

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/CIS336_CreateOMTables.docx”>CreateOMTables.docx(Instructions)

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql”>create_OM_db.sql(Database Script)

STEP 1: Download the Week 5 Lab Instructions and Answer Sheet

Follow the instructions to complete the lab by downloading the following files.

.equella.ecollege.com/file/67acd265-3032-4b50-850b-b98f6d50c25b/24/CIS336Lab5_Instructions.docx”>CIS336Lab5_Instructions.docx

.equella.ecollege.com/file/67acd265-3032-4b50-850b-b98f6d50c25b/24/CIS336Lab5_StudentAnswerSheet.docx”>CIS336Lab5_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docxwhen creating your queries.

STEP 2: Submit Your Answer sheet

Complete the Answer Sheet to show your queries and results and submit according to the lab instructions.

This is the end of Lab #5.

 

 

 

CIS 336 DeVry Week 6 iLab Latest

.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336_W6_iLab.html”>iLab> STEP 1: Download the Week 6 Lab Instructions and Answer Sheet

Lab 6 of 7: Group Functions and Sub queries

.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen

.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?

iLab Overview

Scenario/Summary

Lab 6 will introduce group or aggregate functions and sub queries. Make sure to follow the instructions provided by each step.

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.equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions. (See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

The deliverable for this lab will include the following.

The Student Answer Sheet file that you will download below provides a place for each query and the output of the query. You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 5.

Required Software

Microsoft Office: Word

Use a personal copy or access the software at.devry.edu/”>https://lab.devry.edu. All Steps

MySQL

Access the software at.devry.edu/”>https://devry.edupe.net:8300

Lab Steps

PRELIMINARY STEP: If You Have Not Created the Database Yet, Please Complete.

This lab will utilize the tables that were created in Lab 4. If you have not yet created these tables, you can create the database and tables (used in labs 4–7) by downloading the following files. ·

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/CIS336_CreateOMTables.docx”>CreateOMTables.docx (Instructions) ·

.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/create_OM_db.sql”>create_OM_db.sql (Database Script)

STEP 1: Download the Week 6 Lab Instructions and Answer Sheet

Follow the instructions to complete the lab by downloading the following files. ·

.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336Lab6_Instructions.docx”>CIS336Lab6_Instructions.docx ·

.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336Lab6_StudentAnswerSheet.docx”>CIS336Lab6_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database in.equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docx when creating your queries.

STEP 2: Submit Your Answer Sheet

Complete the answer sheet to show your queries and results, and submit according to the lab instructions.

This is the end of Lab #6