This exercise is worth a total of 10 points. You will receive up to 10 points for accurately creating the table as described in the instructions.
- Instructions
Create a table to store inventory data, named Inventory, which includes these columns:
- StockNum
- Cost
- RetailPrice
- QtyAvailable
- LastPriceChangeDate
When creating the table, use only the int, smallmoney, and smalldatetime datatypes. Use your own judgment as to which datatype best fits each column.