IndividualTemporal DatabasesFor this assignment, you will choose from the following options:£ Option 1: Temporal Hands-On£ Option 2: Temporal Magazine ArticleRead the instructions in the University of Phoenix Material: Temporal Databases located on the student website and select one option to complete the assignment.12Temporal DatabasesSelect and complete one of the following assignments.Option 1: Temporal Hands-OnYou are tasked with creating an inventory price tracking database. Create a table with the following elements:Inventory NumberIntegerInventory DescriptionTextDate Price PreviousDateDate Price CurrentDateDate Price EndDateInventory PriceDecimalThis table will tell you what price the inventory item currently is, what it started at, and what it ends at. The primary key must be a combination of the inventory number and the current price date. 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 would be todays date, and the end date would 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 to be the current date. Then, create a new inventory record with the Date Price Previous is today, Date Price Current is tomorrow (price is effective tomorrow), and Date Price End is null. Remember to bring over the inventory description and inventory number as well.With this work done, create a query that will show you a list of all the current inventory prices.Submit the CREATE Table script, the INSERT script, the CREATE PROCEDURE script, and the SELECT statement with your query.Option 2: Temporal Magazine Article You have been asked by a technology magazine to write an article on temporal databases.Write a 750-to 1000-word article that covers the following:£ What is a temporal database? How does it work?£ How are virtual data stores used in a temporal database?£ How do you derive output from a virtual data store?£ Provide a brief analysis of the process of data mining in a temporal database.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]