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.

Hey Maiko, 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! Best, Ned

Follow this topic

Maiko Ochiai

Last answered:

08 Aug 2022

Posted on:

06 Aug 2022

Resolved: Is that OK to just delete 'Duplicate'?

in Introduction to Excel / Learn How to Create a Database

1 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

08 Aug 2022

Helpful answer

Resolved: Is that OK to just delete 'Duplicate'?

Submit an answer

related questions