What is the database script solutions


You are hired by Northwind as a Database administrator. You are required to integrate some Database script solutions into their existing database to modify data from within the database.

Using the Northwind database, write a SQL DML statement that will modify the data. Base it on the following requirements:

  • .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.
  • .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.
  • .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.
  • .Change the discount in the Order Details table on all orders of productsof anorderedquantity of more than 50 to that of the largest discount ever given on any product.
  • 159 records should be affected
  • .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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: What is the database script solutions
Reference No:- TGS0534568

Expected delivery within 24 Hours