Sql dml for data modification in tables

Assignment Help Basic Computer Science
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

Reference no: EM13829351

Write an assignment statement to calculate area of a circle

Write an assignment statement to calculate the area of a circle. The formula for determining the area, a, of a circle is a = πr2, where r is the radius and π = 3.1416.

Create a bankaccountexception class

Modify each BankAccount class constructor and data entry function so that it throws an exception whenever a client attempts to instantiate a BankAccount with an account numb

Harnessing information management

In Assignment 1, you investigated data analytics and the utilization of data analytics in business. In this assignment, use the company or industry that you selected in Assi

Explain ibm plan to give its it assets-intellectual property

Will IBM's plan to give away some of its IT assets and intellectual property also increase its support of open-source software products like Linux.

Determining the array of integers

Write a method, insertAt, that takes four parameters: an array of integers; the length of the array; an integer, say, insertItem; and an integer, say, index. The method inse

What are the latest technology for intrusion detection

Review scholarly articles and reputable resources and discuss what are the latest technology for intrusion detection and prevention. Please identify/list your references/res

Develop information systems and applications

The systems development life cycle (SDLC) is the traditional process used to develop information systems and applications. The SDLC development process is sequential. Scrum

Data mining from the commercial viewpoint

Q1. Give two examples, apart from those given in the slides, for each of the following: Data mining from the commercial viewpoint Data mining from the scientific viewpoint

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd