MIS528Week 5 iLab: Database Construction Using MySQL Complete Solution
iLab 3 of 4: The Week 5 iLab: Database Construction Using MySQL ( 50 points)
Note!
Submit your assignment to the Dropbox, located at the top of this page.
(See the Syllabus section "Due Dates for Assignments & Exams" for due dates.)
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 named LastName_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
STEP 3: Add Tables, Set Primary Keys and Foreign Keys
Add tables to the MySQL database.
STEP 4: Set Data Types for Table Fields
For every column in every table, update the data type as needed to enforce the domain constraints of the data.
STEP 5: Set Column Constraints
Set the following column constraints in your database.
STEP 6: Add Data to Tables
Write INSERT statements to add at least 2–3 rows of data to each table in your database. Use any values that you like for each of the columns. Remember that you must add data to parent tables before adding data to child tables, because referential integrity is enabled.
STEP 7: Run the Script
Step 8: Save and Upload to Dropbox
When you are done, submit the following files to the Week 5: iLab Dropbox:
Rubric
Points will be awarded according to the following rubrics.
MIS528Week 5 iLab: Database Construction Using MySQL Complete Solution
ET FOREIGN_KEY_CHECKS=0; SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS STUD...
A+ - Thank you!
Thanks for the positive feedback!