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.