following database diagram. Please, run the provided script to create tables and insert data into your database.
ProductPrice History
ProductID
StartDate
EndDate
Price
Product
ProductID
Name
Color
Cost
Price
ProductSubcategory
SubcategoryID Category
Name
SubcategoryID
ModelID
SellStartDate
SellEndDate
ProductCostHistory
ProductID
StartDate
End Date
Cost
8
ProductModel
ModelID
Name
ProductInventorv
ProductID
LocationID
Shelf
Bin
Quantity
Location
LocationID
Name
CostRate
Availability
2 of 2
Paper No: 1
Zoom
+ 100%
Close