Your team is tasked with creating an inventory price-tracking database for a company of your choosing.
Specialist Database Presentation
Your team is tasked with creating an inventory price-tracking database for a company of your choosing.
Complete the following steps in Microsoft® SQL Server® 2016:
Create a table. This table will tell you what price the inventory item started at, what it currently is, and what it ends at. The primary key must be a combination of the inventory number and the current price date. Elements to include in your table are as follows:
a. Inventory Number Integer
b. Inventory Description Text
c. Date Price Previous Date
d. Date Price Current Date
e. Date Price End Date
f. Inventory Price Decimal
Create an insert statement that will be used to initially add an inventory item. Remember that the previous date will be null, the start date will be today’s date, and the end date will be null.
Create a stored procedure that will be used to update the price of an item. The procedure will take the inventory number and a new price.
Update the current record by updating the Date Price End Date to be the current date. Then, create a new inventory record where the Date Price Previous Date is today’s date, Date Price Current Date is tomorrow’s date (price is effective tomorrow), and Date Price End Date is null. Remember to bring over the inventory description and inventory number, as well.
Create a query that will display a list of all the current inventory prices.
Write and run a test script for Steps Two through Four.
Save a screenshot of the results.
Compress your DDL and DML scripts, query, test script, and results into a ZIP file.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
