This is the end of Lab 4 . --------------------------------------------------------------------------------------- CIS 336 iLab 5 Joining Tables FOR MORE CLASSES VISIT
would be output with parentheses , spaces , and hyphens , like this : ( 614 ) 555-5443 . Sort by last name .
This is the end of Lab 4 . --------------------------------------------------------------------------------------- CIS 336 iLab 5 Joining Tables FOR MORE CLASSES VISIT
CIS336 : Lab5 : Joining Tables LAB OVERVIEW Scenario and Summary
www . cis336study . com
Lab 5 will introduce the concept of multi-table JOINS in order to work with data in two or more related tables simultaneously . This lab may be completed using either DeVry ‘ sOmnymbus EDUPE-APP lab environment , or a local copy of the MySQL database running on your own computer using the OM database tables . The lab will utilize a set of tables that are represented by the ERD ( OM _ ERD . docx ) and are created and populated by the script file ( create _ OM _ db . sql ). Follow the instructions in the file CreateOMTables . docx to create your database , tables , and data .
A few IMPORTANT things to note if using EDUPE MySQL :
** There can be NO SPACES in alias names given to a column . For example :
Select unit _ price as ― Retail Price ― from items ; – this does NOT work in EDUPE MySQL .