Solved by a verified expert :iLab> STEP 2: Download
the Week 4 Lab Instructions and Answer Sheet
Lab 4 of 7: Building
the Physical Model
·
·
Listen
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 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 https://lab.devry.edu.
All Steps
MySQL
Access the software at 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.
·
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 in OM_ERD.docx when
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.
