28-Jul-2006, 08:40 AM
| || |
| || || || || |
| || |
Re: Multiple Database Question
On Mon, 24 Jul 2006 13
01 -0700, Matt wrote:
> I was
>wondering if there was a way to design a more efficent database that would be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13837-multiple-database-question.html
>able to house software information, specs, reports, parameters, etc.. without
>creating multiple databases.
Absolutely. You do NOT want to store information in database names,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13837
table names, or field names - you want to store data IN TABLES.
As many tables as you have kinds of entities (real-life persons,
things or events of importance to your application).
I'd expect you would have a table of Programs (or Applications),
related one-to-many to a table of Versions; a table of Specs, related
in some way which you would know better than I; and so on.
I'd suggest you read up on the topic of "Normalization" to get
started. There's a lot of good links at
especially the Database Design 101 links.
John W. Vinson[MVP]