Blog

Calculate Price

Total

Sample Questions

Sample questions

Get a 10%  discount on order above $ 10
Use the following coupon code :

MASTERPIECE2020

Can Someone Help Me With This Northwind Database Work? There Are Two Very Involved Questions.

Write my research paper
You are hired by Northwind as a Database administrator. You are required to integrate some Database script solutions into their existing database (Northwind) 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 CategoryCategory Name = Fast FoodCategory Description = Quick and Easy MealsProvide a SELECT statement to show that the data was inserted. Add the following products for your new Fast-Food category. Product Name = French FriesSupplier 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 = 0Provide 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 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 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 2nd part: You have seen how a database can be set up and accessed. Next, you will look at various applications that could utilize a database. Choose 1 of the database applications or implementations below: Knowledge managementData warehousingData miningDigital librariesObject-oriented databases I chose digital libraries Write a paper that describes the topic in detail. Include a discussion on the following subject areas: History or backgroundDatabase and DBMS requirementsDatabase or schema object considerations and design implicationsConsiderations to integrate the database application into an existing user systemReal-world examples of an implementation Purchase the answer to view it
This is property of essayprince.com. We provide the best Online writing service to our students. Log in today to get access to notch papers