Hi Ken;

This article series is concerned with modeling and implementing the model in such a way as to prevent "bad" data from entering the system (hence the name "Toward Integrity").

As you point out, there is another side to the coin in that particular design and implementation choices we make will impact (usually in a siginificant way) the usability of the data from the query writer's perspective.

I think it would be an excellent idea to take the various pattern implementations from these articles and drill down into some alternative implementations, taking a look at how they impact the ability to ask certain questions. I'll work on these as follow-ups for when this series is done.

TroyK