|
|
Posted by Jerry Stuckle on 05/15/06 16:49
Bent Stigsen wrote:
> Jerry Stuckle wrote:
>
>>
>>My customers aren't. It's because the databases were designed properly in
>>the first place.
>
>
> Sadly not all customers appreciate that. All some care about is the <beep>
> dessert topping. I find that a trifle annoying. I utterly refuse to play
> along with that. Oh what fun I would have, being a ruthless dictator. chop.
> chop.
>
>
> /Bent
Bent,
Unfortunately, that's true. Some have to go through a messy (and expensive)
change cycle to become believers.
At the same time, I've found most databases can be designed with change in mind
very quickly. Just properly normalizing the database does wonders. And in a
case like the one which started this discussion, thinking ahead - yes, now we
have eight options. But would we ever want to add more? If so, a link table is
the way to go.
Sometimes it's not obvious. But understanding the data and how it will be used
is critical to proper database design.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|