Reference no: EM13829351
Problem:
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:
1. 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.
2. 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.
3. 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.
4. 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
5. 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.
Additional Information:
The question is from Computer Science and it explains about writing SQL DML statement which can modify data in tables.
Total Word Limit: 397 Words
|
History and implementation of object oriented databases
: Write a 3-4 page paper that describes any one of the topics in detail. Include a discussion on the following subject areas and include any graphs.
|
|
Create one method that the server takes a piece of code
: Create one method that the server takes a piece of code or data from the user client-side, manipulates it server side after post back, and then provides the manipulated data back to the user.
|
|
What is the principal source of legislative guidance
: 1. What is the principal source of legislative guidance that provides "Special Rules for Long-Term Contracts"? 2. What are the three terms that the IRS uses to define "long-term contract" and what do they mean? 3. What two categories does Sectio..
|
|
What is the difference between prejudice and bias
: What is the difference between prejudice and bias? What is the difference between prejudice and discrimination? Is Shelly showing prejudice, bias, or discrimination in the scenario above
|
|
Sql dml for data modification in tables
: 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:
|
|
Write queries to retrieve data for tsql
: Write SQL statements that will retrieve the following data from a database, using Subqueries and Joins. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:
|
|
Operating system provides a mechanism for configuring
: Operating system provides a mechanism for configuring the behavior of the keyboard attached to the computer. Outline the behavior of the following sets of keys after they have been configured correctly
|
|
Draft paper highlighting the nonfunctional requirements
: draft paper highlighting the nonfunctional requirements and the steps to achieve these requirements. The draft should have some rationalization steps in how technologies are chosen.
|
|
Determine the type of muscle tissues
: The image below shows a longitudinal view of a type of muscle. Note the multiple nuclei that lie at the periphery of the muscle fibers as well as the striations (thin lines) formed by the arrangement of the thick and thin myofilaments.
|