in Oracle Database 10g Express Edition and hr schema

Quantity on hand refers to the minimum quantity for an inventory item to be stocked on the shelf so that you wont run out before the next order. Many practices never establish actual numbers for the quantity to keep on hand and manage inventory by what seems appropriate without establishing a system. This can result in inefficiency and high inventory expenses.

To establish minimum quantity on-hand amounts for each inventory item consider how much product you need so that you dont run out of supplies but also dont keep too much product on the shelf. Establishing re-order points for each inventory items is time-consuming but well worth the time spent initially to improve efficiency and cost-savings long-term. The re-order point is reached once the quantity on hand drops to a point where the inventory may run out of the item if an order is not placed.

Q1. Create a table for an inventory with product_id, produce_name, price, QoH, reorder_point

Create trigger that will display the following message, if the QoH below redorder point.

Product: abc currently got # items in inventory.

Reorder must be initiated.

Q2. Create a tracking table that stores the tracking updating details for inventory table if any changes done for the product price.

Create trigger that will save the product ID, user id, system date, old price, new price.