For AdventureWorks Cycle DB using VisualStudio.

database: https://dataedo.com/samples/html/AdventureWorks/

Execute and ALTER the existing user-defined function to return a table with customer information to include more demographic information.

current function:

CREATE FUNCTION Name_ufnCustomerDemographics RETURNS TABLE AS RETURN

SELECT Customer_ID AS [Customer ID], Customer_Fname AS [First Name], Customer_Lname AS [Last Name], Customer_Phone AS [Phone Number], Customer_Address AS Address FROM Customer

Execute the stored procedure to get top 10 sales records from the Sales Order Detail table.

Create a new stored procedure get top 10 sales records from the Sales Person table.

Create a new stored procedure get top sales records from the Store table.

Execute the existing trigger to add 5 new Products to Product table.

Execute the existing trigger to add 10 new Sales to Sales Order Details table.

Create a trigger to add new Special Offers to the Special Offer table.