I am building a product "database" (actually a spreadsheet, but I want to try to design it so it will smoothly transition into a database). Some of the SKUs I have will cover more than one year (of a model of motorcycle).
If I only allow one specific year in the Year field (e.g. 2006), I will have multiple records for the same SKU with the only difference in the records being the Year field.
Should I instead use a year "range"? If so, what's the best way for me to implement that?
Should I just embrace the redundant SKUs and specify a unique year for each record?
There has to be something UNIQUE about each record ie) VIN number.. If not you should create one.. I really don't understand what you mean by what you wrote though. It would help if I could see a excel file of a small part of the data you are talking about