Bike Stores is implementing a new website to allow online bike purchases. In support of this, a stored procedure called has been created to retrieve a customer record using the customers first name, last name, and password supplied from a website form. From your research on database security, you notice that there is a serious security concern with the procedure. You have established a series of SQL statements to test for security flaws. These statements will be used with two temporary tables called and , which are copies of the and tables, respectively. You must have SQL Server Express and SQL Server Management Studio (SSMS) installed to perform this assessment task. The sample database for this module is called . Download the Database Design Diagram below. Use the database design diagram for your stored procedure assessment.. Please copy each SQL statement into a Microsoft® Word® document. Below that, enter a screenshot of the execution of the SQL showing the code and the resulting output. Below that, enter text explaining the SQL statement and outcome. What has occurred? Was there an adverse impact from the SQL statement execution? Execute the individual SQL statements contained within the following text file in a Microsoft SSMS query window: After executing these statements, explain why the stored procedure is problematic. Did any unauthorized data modifications occur? Did data corruption occur? Were any tables improperly dropped from the database? Based on the Task 2.1 results, the stored procedure has been revised and replaced with a stored procedure called . Execute the individual SQL statements contained within the following text file in a Microsoft SSMS query window: After executing these statements, explain whether the
