+
MIS 582 iLab 3 of 4 The Week 5 iLab Database Construction Using MySQL

MIS 582 iLab 3 of 4 The Week 5 iLab Database Construction Using MySQL

Rating:
Rating
(0)
Author: Harvey Maxwell
Description:

Buy here:

http://www.devrygenius.com/product/mis-582-ilab-3-of-4-the-week-5-ilab-database-construction-using-mysql

iLAB OVERVIEW
Scenario/Summary
In this assignment, you will learn to create a Database Schema from a given ERD. To complete this assignment, you will need to be able to run MySQL via Omnymbus.
Please ensure that you can connect to MySQL/Omnymbus. Consult with the document titled MySQLOmnymbusSupport.docx located in the Doc Sharing folder titled Omnymbus Tutorial Files for instructions. Contact your instructor for help for any issues that you are having with the MySQL/edupe Environment.
Deliverables
SQL script file named LastName_Wk5.sql. That is a txt document with the .sql extension. A text document namedLastName_Wk5_Output.txt. When you are done submit them to the Week 5: iLab Dropbox. Files that have been opened or processed by any software than Notepad are not acceptable. Zipped files are not acceptable and may be returned ungraded.
Required Software
Omnymbus – MySQL in the edupe environment. SQLZOO may be used to test the scripts.
Access the software at https://devry.edupe.net:8300.
Steps 1–8
iLAB STEPS
STEP 1: Entity Relationship Diagram Analysis
Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your MySQL database.
STEP 1: Create a New Database
Create a new database following the naming conventions we are using for our databases, as specified in the tutorial file Creating a Database within MySQL.pdf listed in the doc-sharing folder titled “Omnymbus Tutorial Files” in Doc-Sharing. All of our work in this iLab, will be done under this database.
STEP 2: Create SQL File
Back to Top
To reference, learn and apply MySQL’s own dialect of the SQL language to this iLab, browse through the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc Sharing folder titled My SQL Documents.
Create a script file named LastName_Wk5.sql containing SQL statements created in Steps 3–7 below.
But first include the following commands at the top of your script:SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS STUDENT;
DROP TABLE IF EXISTS CAMPUS;
DROP TABLE IF EXISTS ROOM;
DROP TABLE IF EXISTS COURSE;
DROP TABLE IF EXISTS INSTRUCTOR;
DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
DROP TABLE IF EXISTS CLASS;
DROP TABLE IF EXISTS STUDENT_GRADE;
SET FOREIGN_KEY_CHECKS=1;

STEP 3: Add Tables, Set Primary Keys and Foreign Keys


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial