don't have table structure for 1st question pls help in which way u like to do.. it is important for me to submit the assignment to pass the course. Assignment 2 Question 1 Identifying Customers Brewbeans Coffee Company wants to offer an incentive of free shipping to customers who havent returned to the site since a specified date. Create a procedure named PROMO_SHIP_SP that determines who these customers are and then updates the BB_PROMOLIST table accordingly. The procedure uses the following information: Date cutoffAny customers who havent shopped on the site since this date should be included as incentive participants. Use the basket creation date to reflect shopper activity dates. MonthA three-character month (such as APR) should be added to the promotion table to indicate which month free shipping is effective. YearA four-digit year indicates the year the promotion is effective. promo_flag1 represents free shipping. The BB_PROMOLIST table also has a USED column, which contains the default value N and is updated to Y when the shopper uses the promotion. Test the procedure with the cutoff date 15-FEB-12. Assign free shipping for the month APR and the year 2012. Question 2. Define a cursor to display employees last name and employee number along with their managers last name and manager number. Use Self Join techniques to write this SELECT statement Loop this cursor and fetch it While you are fetching each record, Check each record and do below updates. -IF employees manager id is 102 then update employee table to change commission_pct column to 0.5 -IF employees manager id is 103 then update employee table to change commission_pct column to 0.7 -IF employees manager id is 124 then update employee table to change commission_pct column to 0.9 -For Everybody else then update employee table to change commission_pct column to 0.8 Close the cursor and end the program Test your code Once you execute your code make sure all updates went OK and Execute SELECT * FROM Employees to show me latest commission_pct Give me screen shot of Employees table records after your PL/SQL code run