IT350_Unit2.docx IT350 Advanced Database Concepts IT350-01 Purdue University Global Problem 1: Create a stored procedure that lists the last name, first name, and email address of the staff from all the company sto
...
IT350_Unit2.docx IT350 Advanced Database Concepts IT350-01 Purdue University Global Problem 1: Create a stored procedure that lists the last name, first name, and email address of the staff from all the company stores. The output needs to be in alphabetical order based on the last name then by the first name. The skeleton of the stored procedure is provided below. Problem 2: Create a stored procedure that lists the customers from a specified zip code. The skeleton of the stored procedure is provided below. Problem 3: Create a stored procedure that lists mountain bikes for a specified brand. The output must show the bike name, model year, and list price. The results need to be presented in alphabetical order based on the bike name. The skeleton of the stored procedure is provided below. Problem 4: Create a stored procedure that lists bikes within a specified price range. The output must show the bike name, model year, and list price. The results need to be presented in alphabetical order based on the bike name. The skeleton of the stored procedure is provided below. Problem 5: Create a stored procedure that lists the top five priced bikes at a specified store. The output must show the bike name, model year, and list price. The results need to be presented in descending price order. The skeleton of the stored procedure is provided below. Problem 6: Establish a database view called CompanyStaffListView that lists the last name, first name, and email address of the staff from all th. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
[Show More]