New answers tagged

1

In the ERP I'm developing for, all tables have a surrogate and almost all tables have a natural key. As you can see from Christophe's and Ewan's answers, both types of keys have their pros and cons. So it makes some sense to have both, although this adds complexity. Relationships in this ERP are often done with the surrogate keys, but these keys are almost ...


7

Your current requirements do not take into consideration the effect of time: sooner or later, your company will modernize its catalogue or reorganize its organizational structures. Items will then have to be organized differently: If you opted for a dumb sequential numbering, you don't care: you just change some attributes of the item. And there you go! ...


0

What you are comparing is natural keys vs surrogate keys. Your natural key is productType = SEDAN a surrogate key might be productType = 7 My main problem with surrogate keys is that when humans start to use them they gain a pseudo meaning and become the natural key. Before long instead of saying, "show me a report of all the SEDANS we sold this year&...


Top 50 recent answers are included