Nov 23, 2024
HEP 456 Module 6 Section 14 Communication and Dissemination of The Findings Arizona State University
HEP 456 Module 6 Section 14 Communication and Dissemination of The Findings HEP 456: Health Promotion Program ā¦
Running head: UNIT 7 ASSIGNMENT 1
Unit 7 Assignment
Global University
IT234
1. Use SQL INSERT statements to populate the Categories table with a new category called
Fresh_Produce and a description of Fresh Fruits and Vegetables. There will be no image. Remember, the CategoryID field auto populates so you do not include this in your Insert query. After you have added the category, select all records in the Categories table to see if the record was added.
2 .Use SQL INSERT Command to add a new Region to handle customers in the Midwest. In this case, the RegionID field does not auto populate so you should first find how many regions are in the table before adding the new region and RegionID. Use a query after completing this to verify that the new region has been added.
- Assume that Northwind has decided to change the Employee Title that is now called Sales
Representative to Sales Specialist. Use the SQL UPDATE statement to reflect that change in the
Employees table. After you have updated the Employees table, select all records in the
Employees table to see if the update was performed correctly.
- The Sales department has realigned and before they implement the new region you added, they noted that it really should be called the southeast region. Update the region name to Southeast
and show the regions again to see this change
- An order needs to be deleted. The order number is 11071. Before you can delete the order, you must delete the order details. See the order list shown below. Execute the two queries that are needed to delete the order details and then the order for this order number. Show two windows that show the results of the queries. When completed, search for the order number in orders and show the screenshot of the result.
- A final call comes in from the Sales Department. After presenting the new regional alignment to the board, the board has rejected this part of the reorganization plan. Please DELETE that new region that was added earlier and then changed in Exercise 4 of this Assignment.
