2 ms·
> Natural keys solves this It would be helpful if the article used a natural key. Instead, it uses a primary key that is neither natural nor guaranteed, and is
by jasonlotito 1y ago
> Natural keys solves this
It would be helpful if the article used a natural key. Instead, it uses a primary key that is neither natural nor guaranteed, and is mutable. It makes assumptions that are not true, and that is one of the big dangers in using natural keys.
> If this happens, the designer had a error in his design, and should extend the design to accommodate the facts that escaped him at design time.
This again is a dangerous assumption. The danger here is the assumption that facts don't change. Facts do change. And facts that are true at design time are not necessarily true 1 day later, 1 year later, or 1 decade later, or more.
Again, when the example can't even use a natural key to present it's idea of using natural keys, we have a problem.