Re: How can I organize my database?
From: Giovanni (Giovanni_at_discussions.microsoft.com)
Date: 02/17/05
- Next message: Tim Ferguson: "Re: transferring data"
- Previous message: Christopher Glaeser: "started from scratch"
- In reply to: Jeff Boyce: "Re: How can I organize my database?"
- Next in thread: Jeff Boyce: "Re: How can I organize my database?"
- Reply: Jeff Boyce: "Re: How can I organize my database?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Feb 2005 08:55:16 -0800
Dear Jeff,
I am sorry if I wasn't clear enough, I will try to explain it better.
To give a bit of background, I am doing this for a Humanitarian
Organisation. We need information on other humanitarian organisations' head
quarters, and the various offices under the HQ's juristiction.
I am trying to design a database in order to store information on as many
humanitarian organisations presently with HQ's in Europe as possible, in
particular, I have divided the data in 2 different category such as:
Organisation
- Main Address, Name of the Organisation, Organisation E-mail, Website,
Organisation's telephone number, Organisation's mobile (if any) and a few
more generic categories that apply to the organisation as a whole. I won't
have any problem to do that.
The trouble for my point of view starts when I have to store different kinds
of data under the main organisation file; such as:
Regional Branches
- Regions of operations for each agency. Depending on the organisation, this
could be 1 - 20 different ones.
then:
Country Branches
Countries of operation under each regional office. Depending on the
organisation, number of country offices can vary greatly in number.
then:
District Branches
Districts of operation under each country office. Depending on the
organisation, number of district offices can vary in number.
then possibly:
Partner Organisations
Big organisations normally team up with local grass-root organisations.
Partner organisations will be logged the same as a main organisation record.
As you can see the second data requires more attention in planning the
database, and because I cannot put multiple values into a single record's
field, I would appreciate your advise. I would like to ask you if you can
give me any suggestions in order to plan this database in a proper way.
"Jeff Boyce" wrote:
> Giovanni
>
> I'm not sure I understand what you are trying to do...
>
> Are you asking how you can put multiple values into a single record's field
> (perhaps something like "France; Germany; Italy; ..." in a single field)?
> If so, please reconsider. This reflects a one-to-many relationship between
> your record and the values you are trying to stuff into the single field --
> in a relational database (Access), you don't want to do this.
>
> While it is possible to do, it will only cause both you and Access
> headaches, as you will need to build work-arounds to handle what Access
> could easily manage if the data were more fully normalized.
>
> Please explain a bit more about:
>
> > have the
> > chance to put more countries and more regions for each agency at the same
> > time.
>
> --
> More info, please ...
>
> Jeff Boyce
> <Access MVP>
>
>
> "Giovanni" <Giovanni@discussions.microsoft.com> wrote in message
> news:89E4C624-8A7B-426B-AD1B-D2A04B0975AC@microsoft.com...
> > How will I be able to organize the database in order to put more than one
> > value in one field (such as countries and regions)?
> > The problem is that I need to organize the database in order to have the
> > chance to put more countries and more regions for each agency at the same
> > time.
> > Could you please help me?
>
>
- Next message: Tim Ferguson: "Re: transferring data"
- Previous message: Christopher Glaeser: "started from scratch"
- In reply to: Jeff Boyce: "Re: How can I organize my database?"
- Next in thread: Jeff Boyce: "Re: How can I organize my database?"
- Reply: Jeff Boyce: "Re: How can I organize my database?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
