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

LAB OVERVIEW
Lab 4 will introduce the various aspects of the SQL select statement and the methods of
retrieving data from the database tables. This lab will also introduce the fundamentals of
updating and deleting records. 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.
Any of the following WILL WORK:
Select unit_price as ―RetailPrice‖ from items;
Select unit_price as ―Retail_Price‖ from items;
Select unit_price as Retail_Price from items;
Select unit_price as RetailPrice from items;
**Any calculated fields MUST be given an alias (and note above NO SPACES in alias).
For example:
select unit_price * 2 from items; –this does NOT work in EDUPE MySQL
This will work:
select unit_price * 2 as NewPrice from items;
Deliverables
• Lab Report (Answer Sheet) containing both the student-created SQL command(s) for
each exercise, and the output showing the results obtained. Be sure your name is on the
file.
LAB STEPS: Complete each of the exercises below.