modelling – Learning is not a spectator sport

The AskTOM data model

I popped out a tweet yesterday in Throwback Thursday style showing the date of the first question we took AskTOM

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

I read an interesting article the other day about data modelling and data denormalization. I’ll paraphrase the topic and requirement

Having NOT NULL constraints declared on columns that are genuinely not nullable not only is good practice, but can yield

Yes, I know what you’re thinking. “Here we go again. Another database dude about to get stuck into us telling

Today a question came in, and Swapnasis provided a nice simple test case, which makes my job so much easier.

(This is based on some ‘issues’ a client was having, so the example is architected to make a particular point,