Database program

Problem 1: Using the Script for provided for this week's video do the following The ABC Company now wants you to create stored procedures to calculate federal, state and local taxes for an employee based on their gross income and what state they live in. Federal taxes will be calculated as follows: Gross weekly pay 1923.08 the tax rate will be .09 State and Local taxes will be calculated using the state and local rates in TTaxRates for each employee. 1) Create the stored procedure uspCalculate Taxes that will accept employee ID and weekly salary. Outputs will be federal, state and local tax. Create a cursor within this stored procedure GetTaxRates which will pull state and local rate from TTaxRates for the employee. For federal tax use an IF statement to set the rate based on the weekly gross and then calculate the tax owed. Call this stored proc from within uspGetGrossPav