Question

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:

1. Inventory Number Integer
2. Inventory Description Text
3. Date Price Previous Date
4. Date Price Current Date
5. Date Price End Date
6. Inventory Price Decimal

Answer 1

The following query will do the work

create table YourTableName(
inventoryNumber Int,
inventoryDescription Text,
datePricePrevious Date ,
datePriceCurrent Date,
datePriceEnd Date,
inventoryPrice Decimal,
Primary Key(inventoryNumber,datePriceCurrent)
)