ITCO331-1301A-01 ITCO331_P4 Unit 4 NorthWind Database SQL2008

ITCO331_P4 Unit 4 IP Northwind Database SQL Statements

Download Now Here:
http://www.askassignment.com/product/unit-4-itco331-1301a-01-northwind-database

Features

7 DML statements (3 INSERT, 2 UPDATE, 2 DELETE); 7 SELECT statements

Details:           

Question

Write SQL DML statements that will modify data from within a 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 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.

*Describe optimization and partitioning, and distributed databases with screenshots

Preview Solution:

Sql Script Preview

• This tutorial was purchased  1 time and rated no rating by students like you.
• Posted on Mar. 10, 2013 at 09:37:50AM 

Asked: $20

Email: syedjahangirb@gmail.com to get assignment

Files in Solution:

Files in Solution:
ITCO331-1301A-01_7_DML_7_SELECT_SOLUTION.sql