devry cis336 week 3 ilab latest 2016 march">iLab> Lab Steps Lab three of seven: Constructing the Bodily Mannequin ·" title="Take heed to this web page utilizing ReadSpeaker">Pay attention">What's this? iLab Overview State of affairs/Abstract Starting with this lab, and persevering with via the remaining weeks you can be doing your entire work within the MySQL EDUPE Surroundings. By now you may have acquired your logon ID and password and may have a minimum of made certain you possibly can join. If for any cause you haven't performed so, please accomplish that now earlier than persevering with any additional. If for any cause you can't join, then you have to let the trainer know ASAP in order that any issues may be resolved. On this lab you'll rework a logical database design (knowledge mannequin) right into a bodily mannequin (tables, constraints, and relationships). Your job will likely be to take the connection diagram together with the meta knowledge outlined within the knowledge dictionary and outline the desk constructions and constraints to create the bodily tables. As soon as this has been performed, you will populate the tables with knowledge. Lastly, you'll write SELECT statements to question the tables and confirm the info was populated. Deliverables NOTE Submit your project to the Dropbox, positioned on the prime of this web page. For directions on tips on how to use the Dropbox, learn these">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. Ensure 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 three Required Software program MySQL Entry the software program at">https://devry.edupe.web:8300 Lab Steps STEP 1: Obtain the Week three Lab Directions Full the lab by downloading the next information this week: ·">CIS336Lab3_Instructions.docx ·"> STEP 2: Submit Your SQL Command File Use Notepad to jot down the SQL statements and submit in accordance the lab directions. That is the tip of Lab #three