Re: many fields or many tables? (Understanding DB design)

2004-10-19 Thread Timothy Luoma
On Oct 19, 2004, at 10:17 AM, [EMAIL PROTECTED] wrote: You have already gone a long way to describing your table structure by describing your data elements and their relationships to each other.  Let me try to summarize you descriptions and see if I can show you how to translate your text descri

Re: many fields or many tables? (Understanding DB design)

2004-10-18 Thread Timothy Luoma
Ok, this makes a lot of sense now. (As usual, what seems like more work initially pays off in the end.) Here's a specific question. The parent project is called "TiM". We will, at times, want to pull out information for *everyone*. But more often we will want to pull out information just fro

many fields or many tables? (Understanding DB design)

2004-10-18 Thread Timothy Luoma
I have been tinkering with MySQL long enough to suit what modest needs I have had, but now I need to setup a new DB that is going to have more information in it, and I want to make sure that I am doing it the most efficient way for the long term. Surprisingly, I have not been able to find a goo