----- Original Message ----- From: "John Mayson" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Monday, December 24, 2001 4:40 PM Subject: How many tables?
> How far should I go with this? Right now when I look at my frequency table, it's mostly a > list of numbers. I suppose this is more efficient, but difficult (for me) to work with. I'm sure > once I have a GUI working, it'll be transparent. > > My question is at what point should I stop using these lookup tables? Well, you really shouldn't :-). The way you have broken out the data shows at least some understanding of Normalization rules and you are avoiding repetitive data,which is good. Yes, it may be a pain to have to create a SQL statement with a join, but the fact is that you have a one-to-many relationship here and the use of two tables is perfectly acceptable. Good Luck, Dennis ********************************************** Beridney Computer Services http://www.beridney.com --------------------------------------------------------------------- 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
