Departmental Store Stock Analysis System ItemCost
Time Time_key Day Day_of_week Month Quarter year
Cost_key Cost_Amount Cost_Change_Date Reason_of_change ItemStock
Item Item_key Item_name CategoryID CategoryName Item_type Item_Color Item_Size
Time_key Item_key Location_key Store_key Currency_key Unit_Sold Unit_Sale_Cost Amount_Sold Profit_Amount Profit_percent Unit_Purchased Unit_ Purchase_Cost Amount_Purchased
Store Store_Key
Store_code Store_Name Store_Type Store_Ranking Location_key
Location
Currancy
Location_key Street City State Country
Currency_key Currency_type ConversionRate