Resolved: Is that OK to just delete 'Duplicate'?
In order to create database, is it better to create CODE that is unique throughout all three years? Like YYYY&Companyname&AccountNumber
I thought it was risky to delete date just because it is duplicate. I will never do that in real practice.
You don't want to create a unique code because you want to be able to track how an item develops through time.
For example, if Rockstar sells video games they would want to be able to tell how many units of GTA5 for PS4 were sold in every year. If the code changes every year - they would not know that these are the same units but just in different time periods.
Hope this makes sense!