-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Cal, et al --
...and then Cal Evans said... % % IMHO, etc. *grin* % % Always start with a *fully* (ok, by fully I mean 3rd normal form...mainly % because I still don't fully understand 4th and don't even pretend to Yeah; I'm in the same boat :-) % understand 5th) normalized design. You can always denormalize for speed but % it's real hard to normalize once you are in production. Well, good point. % % Vocal range deserves a 'domainTable' of it's own. Really? Well, OK; I can, as you say, start more normal and then change (does that mean I morph, mutate, or mogrify? :-) % % vocalRangeType % --- % vocalRangeTypeID % === % description % === % % product then has vocalRangeTypeID as a FK. Right. That means another lookup, but it would certainly work. % % Nothing wrong with a table that is just a bunch of FKs to other tables. Oh, I agree :-) % % YMMV, HTH, % =C= Thanks & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- 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+JL8CGb7uCXufRwARAnkAAKDipXtjkqL9lkmY3s2LvrWTTLAubACg3OIN Uz9TVmyblAhy7BbwryF2KEM= =isNN -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php