Has changed the id number for existing products


At times, Brewbean's Coffee Shop, has changed the id number for existing products . In the past, they have had to add a new product a new product row with the new id to the BB_PRODUCT table, modify all the corresponding BB_BASKETITEM and BB_PRODUCTOPTION table rows, and then delete the original product row. Can a trigger be developed to avoid all these steps and handle the UPDATE of the BB_BASKETITEM and BB_PRODUCTOPTION table rows automatically for a given change in product id? If so, create the trigger and test by issuing and UPDATE statement , which changes the IDPRODUCT of 7 to 22. Do a rollback to return the data back to its original state. Also, disable the new trigger after you have completed the assignment.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Has changed the id number for existing products
Reference No:- TGS0108889

Expected delivery within 24 Hours