View Single Post
  #6  
Old March 14th, 2005, 05:22 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

"Jamie Collins" wrote in
oups.com:

Just another thought: alarm bells ring in my head when I see a single
column table. That's why my notes say, if the colours rarely change
then just use:

ALTER TABLE Cars ADD CHECK (car_colour IN ('Red', 'White', 'Blue'));


Do you have any authoritative reference for these alarm bells? I don't
know of any reason within R theory to avoid one-column tables, or any
other kind of all-PK tables.

This design could work if you _knew_ that the colours would _never_,
_ever_ change. It is used sometimes, for example with Gender; but even
then it's something of a short cut.

All the best


Tim F