Re: Surrogate primary key plus unique constraint vs. natural primary key: data integrity?

On 2013-03-19 15:16:54 +0000, Cimode said:

> > And that's probably why my professor had told us to use natural

>> (composite) keys by default; because then you *have to* think about
>> *proper* unification *and* such integrity issues as the one with the
>> overlapping foreign keys are much less likely to remain unnoticed.

That's why we have conceptual data models (as opposed to logical data models) where you don't have to make that choice. Why does this worry you so much?

• Jan Hidders