Question: Please help me go over the steps instructions for Case Questions below I use the Data Processing Book (13rd edition) from David M. Kroenke The
Please help me go over the steps instructions for Case Questions below
I use the Data Processing Book (13rd edition) from David M. Kroenke
The case is from page 354 to p.359 I just only want the answer for question from J to N
Using the QACS database, create an SQL script named QACS-DML-CH07.sql to answer questions J and K.
J. Write an UPDATE statement to change values of ITEM.ItemDescription from Desk Lamp to Desk Lamps.
K. Create and INSERT new data records to record a SALE and the SALE_ITEMs for that sale. Then write a DELETE statement(s) to delete that SALE and all of the items on that SALE. How many DELETE statements did you have to use? Why?
L. Write an SQL statement to create a view called SaleSummaryView that contains SALE.SaleID, SALE.SaleDate, SALE_ITEM.SaleItemID, SALE_ITEM.ItemID, ITEM.ItemDescription, and ITEM.ItemPrice. Run the statement to create the view, and then test the view with an appropriate SQL SELECT statement.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
