CIS 336 DeVry Week 4 iLab latest

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


Contact us at:


CIS 336 DeVry Week 4 iLab Latest


CIS 336 DeVry Week 4 iLab Latest”>iLab> STEP 2: Download the Week 4 Lab Instructions and Answer Sheet

Lab 4 of 7: Building the Physical Model” title=”Listen to this page using ReadSpeaker”>Listen”>What’s this?

iLab Overview


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.


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.)

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”> All Steps

MySQL Access the software at”>

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.”>CreateOMTables.docx(Instructions)”>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.”>CIS336Lab4_Instructions.docx”>CIS336Lab4_StudentAnswerSheet.docx

Be sure to refer to the ERD for the database”>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.