INSTRUCTIONS:

• The SELECT queries that you executed in Part 1 of this assignment ran against a copy of the to the Redcat database that only required "read" permissions. The problems for Part 2, however, require that you have "write" permissions on the database.
• In this assessment, therefore, you will work in your own private database schema, where you will have "write" permission.
• When you start, your database schema will be completely empty. It will contain no tables. Your private database schema is completely under your control. You can add and delete any tables and data you want, including, but not limited to those requried to complete this assignment.
• Before you begin working on the problems in this assessment, You must use the code below to create the Product table. Copy the code below and paste it into one of the SQL editors embedded in the questions.

Create table Product (ProductID Integer Primary Key Not Null, ProductName Varchar (30) Not Null, ManufacturerID Integer Not Null, Category Char (20), Color Char (15), Price Decimal (8,2) Not Null, Description VarChar(100));

• You will receive feedback when it executes correctly. If you create it incorreclty and need to create it again, you must first remove the incorrect table with the SQL statement:

Drop table Product;

• Once you have the necessary table in your database schema, you can delete the above code from the SQL editor. The table you created will remain in your private database schema forever, unless you run SQL code to delete it again. You are now ready to complete the three problems in this assessment.

• Write the code for each problem in it's own SQL editor.
• As you work, you may delete your table and start fresh as many times as you wish. Your table will always remain in your database schema in whatever state you last left it.
• When you are sure your solution to each problem is working as it should, then submit the whole assessment for grading. Remember, remove any extraneous code from your SQL editors. Submit only the specific SQL statements required by each problem definition. The automated grading system will run your statements in its own fresh copy of the Product table in its own database schema, and then grade the results it gets.

Now that the Product table exists in your databse schema, insert the following records into the Product table ProductID ProductName 1500 1502 1504 1505 1506 ManufacturerID Category Color Price Description Leather Sneakers 100 Jogging Sneakers100 High Profile Runners Sport Boots Knee Boots sneakers White 65.00 Real leather uppers sneakers Black 80.00 sneakers White 45.99 boots boots Running with extra cushion 103 103 100 Black 32.99 Easy hiking boot 28.99 Walking, low heel, leather Open in Advanced Editor Save Answer Test Query This problem builds on the previous probem. In the previous problem, you added five records to the Product table. This problem assumes those records exist in the table. In this problem, you will update those records, changing the stored values of some attributes. A GUIDELINES o You can verify that your table contains the correct values by executing this SQL SELECT statement Select from Product" SQL statement in the work area. Be sure, however, to delete these SELECT statements before you submit your assessemtn for grading. It would confuse the automatic grader and harm your score. o Enter your code for this problem into the SQL editor below. o Once you have udated the records in a database, there is no UNDO function. You can, though, use drop the Product table, and use your code from the previous problem to recreate and refill the Product table as many times as you want in order to test your code for this problem. Be sure to delete any DROP statements from yoru code before you submit this assessment for grading Here is the problem: Increase the price of all products in the sneakers category by 5%