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 :