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.

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

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 Mathematics Questions!