Using the producttable from this module (do not modify table or column names) and modify the EventLog trigger that it will store all changed (deleted or updated) values from the Producttable in the ProductHistorytable. Provide the code of your working trigger, code you used to create the ProductHistorytable. Please test 3 different aspects of the code. Below is the producttable and an example test.

SELECT * from ProductTable; PRODUCT!D || PRODUCTNAME LISTPRICE 99.99 49.99 59.99 2 609.99 CATEGORY 299 Small Chest 300 Wave Cruiser 301 Megaland Play Tent 302 Wind-Up Water Swimmers 303 Garmin Pocket or Vehicle GPS Navigator 10 2 12 SELECT*from ProductHistoryTable; B PRODU PRODU IBI LISTPRICECATEGO B MODIFD Test update for multiple rows: Update to S55 prices for item 299 to S55 UPDATE ProductTable SET ListPrice = 55 where ProductID IN (299, 302); SELECT from EventLogTable; to show that two rows showing old prices were inserted UPDATE ProductTable set ListPrice55 where productid in (299,302) elect from producthistorytable; Script Output x [> Query Result x Fu QL All Rows Fetched: 2in 0.004 seconds PRODUCTID PRODUCTNAME LISTPRICE! CATEGORY MODIFDATE 299 Small Chest 99.99 10 06.01.2018:16:36:59 2 302 Wind-Up Water Swimmers 2 1106.01.2018:16:36:59