I have entity "Item" and it has attribute "Price", and the Price-s change and must be recorded as price history. Which database design would be appropriate?
TABLE Item (ID, Price);
TABLE ItemPriceHistory (ItemID, Price, Date)
or
other way?
If Item is firstly inserted into system, then ItemPriceHistory stays empty, after first change of that item over column "Item.Price" we would insert record with old Price into table ItemPriceHistory.
Thanks.