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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!