Question: 20. Now let us do something more complex with a trigger. Imagine that we would like to store a history of price changes for each

20. Now let us do something more complex with a trigger. Imagine that we would like to store a history of price changes for each item. To do so, we would first need to create an Item_price_history table that stores at a minimum a reference to the item, its old price, its new price, and the date of the change. We could then define a trigger on the Item table that updates the Item_price_history table whenever an item price is updated. For this step, go ahead and create the Item_price_history table as described. Paste in an updated ERD which includes that new table. Also capture a screenshot of the table creation in SQL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
