MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:David T-G Date:January 14 2003 11:49pm
Subject:when to normalize out to a table
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, all --

I wonder if there's a best-practice line of when to bother to normalize
data out to a table.  Certainly I wouldn't want to have a table of
integers and have a column in another table point into it :-) and almost
certainly I'd want to point out to a table of personnel rather than list
the info -- even just the name -- in the table of other info.

Well, for the music catalog I've started I have to track the vocal range
of the piece.  I only have five values (high, medium high, medium, medium
low, low) and I could at least use 5 logical abbreviations (HH, MH, MM,
ML, LL), and I might even come up with 5 single-letter abbreviations that
would thus be exactly as efficient as going out to another table via a
smallint pointer -- and yet I wouldn't ever have to dereference to see
what range I meant.

How does one decide what to do in a grey area of this sort -- in this
situation, for example? ;-)


TIA & HAND

mysql query,
:-D
- -- 
David T-G                      * There is too much animal courage in 
(play) davidtg@stripped * society and not sufficient moral courage.
(work) davidtgwork@stripped  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/      Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+JKHwGb7uCXufRwARApErAJ4r4DyzeSJVt4+/I7H7isVd77zUQQCg0igD
vabIu29v+Jm5s0HOMaGnsLE=
=MRq6
-----END PGP SIGNATURE-----
Thread
when to normalize out to a tableDavid T-G15 Jan
  • RE: when to normalize out to a tableCal Evans15 Jan
    • Re: when to normalize out to a tableDavid T-G15 Jan
      • RE: when to normalize out to a tableCal Evans15 Jan
        • Re: when to normalize out to a tableDavid T-G15 Jan
          • RE: when to normalize out to a tableCal Evans15 Jan
            • Re: when to normalize out to a tableDavid T-G15 Jan
          • Re: when to normalize out to a tableMichael T. Babcock23 Feb
    • Re: when to normalize out to a tableMichael T. Babcock15 Jan