News for hackers. Stuff that matters.
Re:Database Design Mistakes by chris_wot on Saturday July 20, 2013 @07:53PM (#6077078)
Point 5 makes no sense. The whole point in using a surrogate key is that a natural key is almost always flawed. There are no good reasons for the advise he gives for point 5, in fact it is a mistake to do what he says!
Re:Database Design Mistakes by siddboots on Saturday July 20, 2013 @09:03PM (#6077320)
I think his point could have been made clearer, but he's really just saying that there will often be a mutable natural key that is captured in the modelled data, and that it makes sense to enforced constraints over that key if you know that the constraints exist.
Re:Database Design Mistakes by chris_wot on Sunday July 21, 2013 @01:42AM (#6077964)
Ok, maybe. But I can only think of examples where if the schematic was normalized properly then it would be a non-issue.