CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 48

15. Using the SUBSTRING and CONCAT functions, write a query to display each
customer name as a single field in the format ―Jones, Tom‖ with a heading of Customer
along with the customer_phone field in a nicely formatted calculated column named
Phone. For example, a record containing the customer_phone value 6145535443 would
be output with parentheses, spaces, and hyphens, like this: [phone]. Sort by last
name.
This is the end of Lab 4.
---------------------------------------------------------------------------------
CIS 336 iLab 5 Joining Tables
For more course tutorials visit
www.uophelp .com
CIS336: Lab5: Joining Tables
LAB OVERVIEW
Scenario and Summary
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.