Itco331 – unit 4 individual project

You are hired by Northwind as a Database administrator. You are required to integrate some Database script solutions into their existing database (Northwind) 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:

Don't use plagiarized sources. Get Your Custom Essay on
Itco331 – unit 4 individual project
Just from $13/Page
Order Essay

•.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 products of an ordered quantity 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.

 

This assignment will also be assessed using additional criteria provided here.

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper