Using SQL Table

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));

Insert records into Product table above

A. Increase the price of all products in the sneakers category by 5%.

B. Delete all products from the Product table that are manufactured by Manufacturer 100.

A. Increase the price of all products in the sneakers category by 5%.

B. Delete all products from the Product table that are manufactured by Manufacturer 100.

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 Leather Sneakers Jogging Sneakers High Profile Runners Sport Boots Knee Boots ManufacturerID Category Color Price |Description 100 100 103 103 100 sneakers White 65.00Real leather uppers sneakers Black 80.00 sneakers White 45.99Running with extra cushion boots Black |32.99 Easy hiking boot boots 28.99 Walking, low heel, leather