Development has progressed from the reporting/searching screens to other functionality. Put together scripts to prove these concepts for editing data:

Development has progressed from the reporting/searching screens to other functionality. Put together scripts to prove these concepts for editing data:

1.Using the Northwind database, write a script to insert the following data:
One new Category
Name = Junk Food, Description = yummy delights

2.Add a Product for your new Junk Food category.
Product = Twinkies, Supplier = Tokyo Traders, Category = Junk Food
QuantityPerUnit = 10 boxes
UnitsInStock = 0, UnitsOnOrder = 0, ReorderLevel = 10, Disabled = 0

3.In an attempt to liquidate some Products, in the Northwind database, provide a script to set all Products in the Condiments category that have less than 20 units in stock to a price of $5.00 and disable them. HINT: four records should be affected

4.Your boss has decided against the new Junk Food Category. Provide a script to delete the Junk Food Category as well as any Products assigned to that category.
Copy and paste your scripts (no screen shots necessary) into a Word .doc

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]