News for hackers. Stuff that matters.
Re:Why are so many men pregnant? Data entry mistakes in the ... by olavk on Thursday May 17, 2012 @06:43AM (#3986332)
Do you mean that this kind of error can be prevented at the DB level? It is only possible in very trivial cases, like you know a man can't be pregnant. In the DB you can only ensure that data is internally consistent, not that the data entered corresponds to the real world facts, which is really the issue here.
Re:Why are so many men pregnant? Data entry mistakes in the ... by gaius on Thursday May 17, 2012 @07:01AM (#3986379)
Right, no DB can enforce checks for things that could be true but aren't (e.g. a trigger can't prevent you from wrongly entering an adult woman as pregnant, she might even look pregnant to the eye and not be). But a DB can prevent you doing things that don't make sense (e.g. age must be a positive number, men can't be pregnant, etc etc).