So consequently in that case, is it better to look for natural or surrogate keys?
You need to tell us more about you problem domain if you expect an answer…
It’s very generic question. Let say I have a table with unique values, say tags or zip code. I know that this approach would be useful in case when one has to store additional data. But let’s assume for a moment that it’s a 1 column table.
Often a surrogate key (db generated, AUTO_INCREMENT) is a good option.
Sounds reasonable. Thank you for the explanation.