1. Using the above table structure: a. Write a scr ipt to create the Employees table. b. Write a scr ipt to alter the Employees table to increase the length of the [lastName] field from 50 - 60 characters c. Create a stored procedure that takes in a parameter of a Department Name and returns all the employees’ details for the department. If no department name is passed in, return all the employees. d. Create a scr ipt that returns each department name and the number of employees in each department. e. Create a scr ipt that filters by department name and returns the number of Males and females in the department f. Create a scr ipt that filters by [employNo] and returns the salary amount as well as the department name. g. Assuming that the relationship between Employees and [salaryLevel] does not exist, create a scr ipt that returns all the employees that have a [salarylevelID] that is not in the Salary level table.

Packet : script.txt filelist

• We are an exchange download platform that only provides communication channels. The downloaded content comes from the internet. Except for download issues, please Google on your own.
• The downloaded content is provided for members to upload. If it unintentionally infringes on your copyright, please contact us.
• Please use Winrar for decompression tools
• If download fail, Try it againg or Feedback to us.
• If downloaded content did not match the introduction, Feedback to us，Confirm and will be refund.
• Before downloading, you can inquire through the uploaded person information

Nothing．