1. Create a trigger named Check_Availability. The trigger raises an application error when a product is out of stock or not enough to fulfil an order. It should display a message on the estimated date when the product will be available (use expected delivery date). Include the following test statement in your script file:

Insert Into order_lines values (388,1023,100,20,2,160);

Product Table (Product_ID, Category_ID, Product_Name, Product_Desc, Status, Comments);

Order_Lines Table (Order_ID, Product_ID, Actual_Price, Discount, Quantity, Total_Amount);

Order (Order_ID, Order_Date, Customer_ID, Employee_ID, Ship_Date, Shipment_Method_ID, Paid, Order-Status, Notes);)