CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 67

LAB OVERVIEW

Lab 7 will introduce the concept of database views. 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:

LAB OVERVIEW

Lab 7 will introduce the concept of database views. 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: