[Tagging] football or soccer ?

Anthony osm at inbox.org
Mon Aug 2 15:56:18 BST 2010


> On Thu, Jul 1, 2010 at 8:08 AM, John F. Eldredge <john at jfeldredge.com>
> wrote:
>> In fact, the technique of having the user select from a list of words, but
>> actually storing the value as an arbitrary ID (generally numeric), is the
>> recommended technique in database design.  It is called "normalizing the
>> database".

> On 01/07/2010 15:25, Anthony wrote:
> Umm...no.  At least, not exactly.  If a single column is independent from
> other columns, it is not necessary for normalization to store it as an
> arbitrary ID.  (For example, if you have a database table containing a
> driver's license number, date of birth, and hair color, you generally
> wouldn't store the hair color as an arbitrary ID and then have a separate
> table to look up the hair color.  It certainly isn't necessary for
> normalization.  Assuming driver's license number is your primary key, hair
> color is a fact about the key, the whole key, and nothing but the key.)

On Mon, Aug 2, 2010 at 4:38 AM, Colin Smale <colin.smale at xs4all.nl> wrote:
> Actually that would be exactly what you would do, assuming you want the list
> of colours to be controlled and finite.

No it isn't.  If I wanted the list of colors to be controlled and
finite I'd use a check constraint.

> Which DBMS do you call crappy and which do you call good?

Sorry, not going to play that game.



More information about the Tagging mailing list