Validity Date Data Modelling Quesiton
We want to design a Product Repository.
The main table will store product information based on VALIDITY DATES.
We have say 30 fields in the main table.
Any of the 30 fields could change based on the validity date.
We have the practise of working with SKU in the future.
<u>ProductID Description SalesUnit Start Validity Date End Validity Date</u>
Printer01 HP Inkjet EA 02/06/2006 06/06/2006
Printer01 HP Special Jet EA 06/07/2006 04/04/2007
How can you represent the same SKU based on validity dates?
Note: Any of the 30 fields in the main table could change based on validity date.
In the Example above, Printer01 is called HP Inkjet based on a validity date.
The same Product Printer01 is called HP Special Jet based on a future validity date.
Qn: How can we model this scenario.
Any leads is appreciated.
I promise to reward the answers which are helpful.