CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 57

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_Pric e 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.