.equella.ecollege.com/file/ef4a2735-4d7d-4083-8756-20c14fb90995/13/CIS336_W3_iLab.html”>iLab> Lab Steps
Lab 3 of seven: Constructing
the Bodily Mannequin
·
.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Hearken to this web page utilizing ReadSpeaker”>Hear
.equella.ecollege.com/file/2c8d44cf-16de-4684-900a-8088186a0f88/1/ReadSpeaker.html”>What’s this?
iLab Overview
State of affairs/Abstract
Starting with this lab, and persevering with by way of
the remaining weeks you may be doing your entire work within the MySQL EDUPE
Setting. By now you will have obtained your logon ID and password and may
have not less than made positive you possibly can join. If for any motive you haven’t finished
so, please achieve this now earlier than persevering with any additional. If for any motive you
can’t join, then you’ll want to let the teacher know ASAP in order that any
issues may be resolved.
On this lab you’ll remodel a logical
database design (information mannequin) right into a bodily mannequin (tables, constraints, and
relationships). Your job will likely be to take the connection diagram together with
the meta information outlined within the information dictionary and outline the desk constructions
and constraints to create the bodily tables. As soon as this has been finished, you
will populate the tables with information. Lastly, you’ll write SELECT statements to
question the tables and confirm the information was populated.
Deliverables
NOTE
Submit your project to the Dropbox, positioned
on the prime of this web page. For directions on how you can use the Dropbox, learn these .equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step directions.
(See the Syllabus
part “Due Dates for Assignments & Exams” for due dates.)
1.
Your script file. Create
this file in Notepad, not Phrase. Be sure that your identify is in a
remark space on the prime of the script file. Use a double sprint to create a
one-line remark.
âJacob Smith
âLab 3
Required Software program
MySQL
Entry the software program at .devry.edu/”>https://devry.edupe.internet:8300
Lab Steps
STEP 1: Obtain the
Week 3 Lab Directions
Full the lab by downloading the next
recordsdata 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 down the SQL statements and
submit in accordance the lab directions.
That is the top of Lab
#3
