ITCO331_P4 Unit 4 IP Northwind Database SQL Statements
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:
ITCO331-1301A-01_7_DML_7_SELECT_SOLUTION.sql
No comments:
Post a Comment