ITCO331 Unit 4 – New – Perfect Solution

Lab Price = $10
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.
Problem Statement
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:

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.

Please submit your assignment.

Relevant Material
Screenshots
screenshot_query2

screenshot_query2

screenshot_afterexecution_query3

screenshot_afterexecution_query3

Instructions
* Please click on “Buy Now” button to complete the purchase.Please note that the payment is done through PayPal.
* If you have any issues with the payment method, please let us know at support@iqrajavaid.com and that can be discussed and considered.
* Your paypal has to be pre-loaded in order to complete the purchase or otherwise please discuss it with us at support@iqrajavaid.com.
* As soon as the payment is received through PayPal, download link of the solution will automatically be sent to the address used in Paypal.
* Please check your junk mails as the download link email might go there.
* All the contents are compressed in one zip folder.
* In case if you get stuck at any point during the payment process, please immediately contact us at support@iqrajavaid.com and we will fix it with you.
* We try our best to reach back to you on immediate basis. However, please expect to get a response within 8 hours from our side.
* Comments/Feedbacks are truely welcomed and there might be some incentives for you for the next lab/quiz/assignment.
* In case of any query, please donot hesitate to contact us at support@iqrajavaid.com.

******************************************** Good Luck ***************************************************

Privacy Policy
We take your privacy seriously and will take all measures to protect your personal information.
Any personal information received will only be used to fill your order. We will not sell or redistribute your information to anyone.
Refund Policy
Incase you face any issues with the tutorial, please free to contact us on support@iqrajavaid.com
We will try our best to resolve the issue and if still persists we can discuss for a refund in case its required.
Payment Details
Lab Price = $10
Please feel free to send us your queries at: support@iqrajavaid.com
Note: In case if your problem statement is updated, please donot hesitate us and send it to us at support@iqrajavaid.com. We would surely like to help you in this regard.

Leave a Reply