You are hired by Northwind as a Database administrator. You are required to integrate some Database script solutions into their existing database to modify data from within the database.
Using the Northwind database, write a SQL DML statement that will modify the data. Base it on the following requirements:
- .Using the Northwind database, write a script to insert the following data:
- 1 new Category
- Category Name = Fast Food
- Category Description = Quick and Easy Meals
- Provide a SELECT statement to show that the data was inserted.
- .Add the following products for your new Fast-Food category.
- Product Name = French Fries
- Supplier Name = Ma Maison
- Category Name = Fast Food
- QuantityPerUnit = 20 Sticks
- UnitPrice = 4.99
- UnitsInStock = 10
- UnitsOnOrder = 25
- ReorderLevel = 10
- Disabled = 0
- Product Name = Hamburger
- Supplier Name = Grandma Kelly's Homestead
- Category Name = Fast Food
- QuantityPerUnit = 1 Patty
- Unit Price 6.99
- UnitsInStock = 0
- UnitsOnOrder = 50
- ReorderLevel = 5
- Disabled = 0
- Provide a SELECT statement to show that the data was inserted.
- .In an attempt to liquidate some products, provide a script to set all products in the Confections category that have more than 50 units in stock to a price of $10, and disable them.
- 2 records should be affected.
- .Change the discount in the Order Details table on all orders of productsof anorderedquantity of more than 50 to that of the largest discount ever given on any product.
- 159 records should be affected
- .You have decided against the new Fast-Food category. Provide a SQL statement to delete the Fast-Food category as well as any products assigned to that category.