CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 66

14. Write a query that displays the order id, order date, and employee
name as a single field labeled Employee for each order that an
employee assisted with.
15. Write a query that displays the order id, order date, customer name
as a single field labeled Customer for all orders for the sales rep
Thomas Hardy, sorted by customer last name.
This is the end of Lab 5.
===================================================

CIS 336 iLab7 Working with Views

FOR MORE CLASSES VISIT
www.cis336study.com
CIS-336: Lab7: Working with Views
LAB OVERVIEW
Lab 7 will introduce the concept of database views. This lab
may be completed using either DeVry‟sOmnymbus EDUPEAPP 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.