here is my week 4 lab, need help with it, please let me know if you can help
here is my week 4 lab, need help with it, please let me know if you can help
CIS336: Lab 4: Introduction to Select, Insert,Update, and Delete StatementsLAB OVERVIEWLab 4 will introduce the various aspects of the SQL select statement and the methods of retrieving datafrom the database tables. This lab will also introduce the fundamentals of upda±ng and dele±ng records.This lab may be completed using either DeVry’s Omnymbus EDUPE-APP lab environment, or a local copyof the MySQL database running on your own computer using the OM database tables. The lab will u±lizea set of tables that are represented by the ERD (OM_ERD.docx) and are created and populated by thescript Fle (create_OM_db.sql).²ollow the instruc±ons in the FleCreateOMTables.docxto create yourdatabase, 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.²or 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 Felds MUST be given an alias (and note above NO SPACES in alias).²or example:select unit_price * 2 from items;—this does NOT work in EDUPE MySQLThis will work:select unit_price * 2 as NewPrice from items;DeliverablesLab Report (Answer Sheet) containing both the student-created SQL command(s) for eachexercise, and the output showing the results obtained.Be sure your name is on the Fle.LAB STEPS:Complete each of the exercises below.1.Write a query that displays a list of all customers showingthe customer Frst name, last name, andphone number.Sort the results by customer last name, then Frst name.CIS336 Lab 4 Instruc±onsPage 1
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
