Appropriate Design

2008-09-17 Thread Jeffrey Santos
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 learning about databases. I'm developing an application that will require information

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 design

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

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 will

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 learning

Re: Appropriate Design

2008-09-17 Thread Jeffrey Santos
recipient. Sender does not necessarily endorse content contained within this transmission. Date: Wed, 17 Sep 2008 09:57:05 -0400 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Appropriate Design CC: mysql@lists.mysql.com On Wed, Sep 17, 2008 at 5:46 AM, Jeffrey Santos

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

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 information.

RE: Appropriate Design

2008-09-17 Thread Geert-Jan Brits
: 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 bibliography for the sources of that information. If I

Re: Appropriate Design

2008-09-17 Thread Jeffrey Santos
without requiring joins. Hope this makes sense, Cheers, Geert-Jan -Oorspronkelijk bericht- Van: Jeffrey Santos [mailto:[EMAIL PROTECTED] Verzonden: woensdag 17 september 2008 17:39 Aan: David Ashley CC: mysql@lists.mysql.com Onderwerp: Re: Appropriate Design Hi David, My project