Reference no: EM13842130
1: Write a script to create a new Product Category called ‘Shoes'. This category belongs under the category Clothing. Only ParentProductCategoryID and Name are required. The system will assign values for the other fields. Use a subquery to find the value for ParentProductCategoryID.
2: Provide a SELECT statement to show that the new Product Category Shoes was inserted.
3: Add the following two products in the data base for your new Shoes category. Insert other appropriate column values as necessary. Use a subquery to find the ProductCategoryID for Shoes.
4: Provide a SELECT statement to show only the newly inserted products using a subquery to find the ProductCategoryID for Shoes.
Name
|
Product Category
|
Product Number
|
Standard Cost
|
List Price
|
Sell Start Date
|
Men's Black Size 10
|
Shoes
|
SH-1000
|
30.99
|
55.99
|
Today's date
|
Woman's White Size 38
|
Shoes
|
SH-2000
|
28.99
|
50.99
|
Today's date
|
5: Utilizing a subquery, provide a script to display all product fields for products in the Mountain Frames Product category that are silver. Look at the List Price.
6: Utilizing a subquery, increase the list price by 5% for products in the Mountain Frames Product category that are silver. Rerun Query #5 and verify that the price has changed.
7: Utilizing a subquery, change the unit price discount in the Sales Order Details table on all orders of products of an ordered quantity of more than 15 to that of the largest discount ever given on any product.
8: You have decided against the new Fast-Food category. Provide SQL scripts to delete the Fast-Food category as well as any products assigned to that category. Use a subquery to delete the products
Collaborated to write uniform criminal code
: A group of attorneys, judges and law professionals have collaborated to write a uniform criminal code. The code would create uniformity in criminal law across the United States, defining what constitutes a misdemeanour, what constitutes a felony, how..
|
Bill desires rate of return on this investment
: Bill Martin made an investment several years ago, and he now has an option as to how it will take the return on that investment. Option 1 is to receive an immediate cash payment of $100,000. Option 2 is to receive a payment of $10,000 per year for th..
|
Report on the usefulness of birth order as a construct
: Create a 700-word report on the usefulness of birth order as a construct. You may review this week's readings, utilize the birth order resources, or other experts in this area
|
What documentation issued by a bank decreases the balance
: How is a business's certified check treated in doing the business's bank reconciliation? What documentation issued by a bank decreases the balance in a company's checking account balance at the bank?
|
Write a script to create a new product category
: Write a script to create a new Product Category called ‘Shoes'. This category belongs under the category Clothing. Only ParentProductCategoryID and Name are required.
|
Estimate the internal rate of return on investment
: Scuba Supply Company is considering making an investment of $1,000,000 and estimates that the result of the investment will yield the following returns over the next five years: Year 1 ($500,000) - a loss Year 2 $200,000 Year 3 $610,000 Year 4 $740,0..
|
Defending the efficacy treatment approaches
: Select two of the treatment approaches discussed in the modules and develop a position paper defending the efficacy of these two approaches for out-patient therapy
|
Who is interested in being involved in the pursuit of health
: Why policy competence is important to anyone who is interested in being involved in the pursuit of health?
|
Organizational development practitioner be aware
: When an action researcher is dealing with an organization that is under organized, what are key steps in the change process? Explain. What problems associated with planned change should the Organizational Development practitioner be aware of? How mig..
|