Write MySQL, PL/SQL, or T-SQL procedures to accomplish the following tasks: a. Obtain the name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT. b. Obtain the invoice date, customer ID, and first and last names for the invoice whose number currently is stored in |_INVOICE_NUM. Place these values in the variables [INVOICE_DATE, |_CUST_ID, and I_CUST_NAME, respectively. Output the contents of I_INVOICE_DATE, I_CUST_ID, and I_CUST_NAME. c. Add a row to the INVOICE table. d. Change the date of the invoice whose number is stored in _INVOICE_NUM to the date currently found in I_INVOICE_DATE e. Delete the invoice whose number is stored in I_INVOICE_NUM. 6. Write MySQL, PL/SQL, or T-SQL procedures to retrieve and output the item ID, description, location, and price of every item in the category stored in I_CATEGORY. 7. Write a stored procedure in MySQL, PL/SQL, or T-SQL that changes the price of an item with a given item ID. How would you use this stored procedure to change the price of item AD72 to $84.99?