Re: Appropriate Design

2008-09-17 Thread Jeffrey Santos
detail-page requires only 1 query to the > document-type table of which the entity clicked on happens to belong > (remember I entity could only belong to 1 type) > 3. If your application enables the user to specify to search in a specific > document-type, that document-type table could be used

RE: Appropriate Design

2008-09-17 Thread Geert-Jan Brits
rzonden: woensdag 17 september 2008 17:39 Aan: David Ashley CC: mysql@lists.mysql.com Onderwerp: Re: Appropriate Design Hi David, My project involves storing information that could have been gathered from wildly different sources. You can think of this part of the database as a sort of bibliograp

Re: Appropriate Design

2008-09-17 Thread David Ashley
On Wed, Sep 17, 2008 at 11:38 AM, Jeffrey Santos <[EMAIL PROTECTED]>wrote: > Hi David, > > My project involves storing information that could have been gathered from > wildly different sources. You can think of this part of the database as a > sort of bibliography for the sources of that informat

Re: Appropriate Design

2008-09-17 Thread Jeffrey Santos
Hi David, My project involves storing information that could have been gathered from wildly different sources. You can think of this part of the database as a sort of bibliography for the sources of that information. If I gathered information from a book, for instance, there are some generally r

Re: Appropriate Design

2008-09-17 Thread Jeffrey Santos
ission is of a confidential nature and Sender > does not endorse distribution to any party other than intended recipient. > Sender does not necessarily endorse content contained within this > transmission. > > > > Date: Wed, 17 Sep 2008 09:57:05 -0400 > > From: [EMAIL PROT

Re: Appropriate Design

2008-09-17 Thread David Ashley
On Wed, Sep 17, 2008 at 5:46 AM, Jeffrey Santos <[EMAIL PROTECTED]> wrote: > I'm not sure if this is the right list to ask such a question; if not, any > direction as to the appropriate forum would be much appreciated! > > This may be a simple question, but I'm still on the early stages of my > le

Re: Appropriate Design

2008-09-17 Thread Brent Baisley
On Wed, Sep 17, 2008 at 7:19 AM, Kevin Hunter <[EMAIL PROTECTED]> wrote: > At 5:46am -0400 on Wed, 17 Sep 2008, Jeffrey Santos wrote: >> I'm developing an application >> that will require information from various sources. Since what >> might be considered required information about those sources w

Re: Appropriate Design

2008-09-17 Thread Jeffrey Santos
Kevin, Thank you for the extensive reply, the information you provide makes perfect sense. I have read about normalization so was anticipating that choice #2 would probably be more appropriate. In terms of the specifics of the project... This portion of the database would act as a sort of biblio

Re: Appropriate Design

2008-09-17 Thread Kevin Hunter
At 5:46am -0400 on Wed, 17 Sep 2008, Jeffrey Santos wrote: > I'm developing an application > that will require information from various sources. Since what > might be considered required information about those sources will > vary (occasionally dramatically), I'm unsure as to the correct > desi