devry cis336 week 3 ilab latest 2016 march
.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