And here is an access database. https://lookaside.fbsbx.com/file/hw2accessdatabase2000.mdb?token=AWyTcRV-Xc5QK3CMjxZsfxPN-ZfdWwfwOgTTmH8aB9EAqhbHpSfd7L_4rzv5sJXorsm8wkJTSA6OR_uCinBJw3XGUJj0ztNL_eArcmpQ2P_2YFqfCR4rC879OI0H761p0nQIK3fY_eh5AMTSJW6f5vw49KbJHgKCzk2mWLP6ZKR4-gtAuR-r3SCS6xGWDUMji0yGqaMHz4nGtd3_XG_p3zHk

Custome CustNo CustFirstName CustLastName CustStreet CustCity CustState CustZip CustBal Employee EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate Employee 1 EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate Supplier SuppNo SuppName SuppEmail SuppURL SuppDiscount Product ProdNo ProdName SuppNo ProdQOH ProdPrice Purchase OrderTbl PurchDate SuppNo PurchPayMethod PurchDelDate OrdNo OrdDate CustNo EmpNo OrdName OrdStreet OrdCity OrdState OrdZip PurchLine ProdNo PurchNo PurchQty PurchUnitCost OrdLine OrdNo ProdNo Qty Write a PL/SQL procedure to insert a new row into the Product table using input parameters for the product number, product name, product price, next ship date, quantity on hand, and supplier number. For a successful insert, display an appropriate message. If an error occurs in the INSERT statement, raise an exception with an appropriate error messagee 2. Revise problem 1 to generate an output value instead of displaying a message about a successful insert. In addition, the revised procedure should catch a duplicate primary key error. If the user tries to insert a row with an existing product number, your procedure should raise an exception with an appropriate error message 3. Write a trigger to propagate updates to the Product table after delete operations on the PurchLine table. The quantity on hand (ProdQOH) should increase by the old purchase quantity (PurchQty) Custome CustNo CustFirstName CustLastName CustStreet CustCity CustState CustZip CustBal Employee EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate Employee 1 EmpNo EmpFirstName EmpLastName EmpPhone SupEmpNo EmpCommRate Supplier SuppNo SuppName SuppEmail SuppURL SuppDiscount Product ProdNo ProdName SuppNo ProdQOH ProdPrice Purchase OrderTbl PurchDate SuppNo PurchPayMethod PurchDelDate OrdNo OrdDate CustNo EmpNo OrdName OrdStreet OrdCity OrdState OrdZip PurchLine ProdNo PurchNo PurchQty PurchUnitCost OrdLine OrdNo ProdNo Qty Write a PL/SQL procedure to insert a new row into the Product table using input parameters for the product number, product name, product price, next ship date, quantity on hand, and supplier number. For a successful insert, display an appropriate message. If an error occurs in the INSERT statement, raise an exception with an appropriate error messagee 2. Revise problem 1 to generate an output value instead of displaying a message about a successful insert. In addition, the revised procedure should catch a duplicate primary key error. If the user tries to insert a row with an existing product number, your procedure should raise an exception with an appropriate error message 3. Write a trigger to propagate updates to the Product table after delete operations on the PurchLine table. The quantity on hand (ProdQOH) should increase by the old purchase quantity (PurchQty)