Gala Database

I have to design a data base for a Gala Event.

I need tables for:

Entrants
Judges
Sponsors
Categories
Results/Event

I take it the above will be my five tables. Can someone identify the
primary keys here for me and the relationships between the five
tables? I have tried but always end up with one relation being
indeterminate.........!

It is getting very frustrating now

Brenda

"Brenda" <brenda.sendall@ntlworld.com> wrote in message
news:f8fc6bfe.0405090528.5ac76d80@posting.google.c om...[color=blue]
> I have to design a data base for a Gala Event.
>
> I need tables for:
>
> Entrants
> Judges
> Sponsors
> Categories
> Results/Event
>
> I take it the above will be my five tables. Can someone identify the
> primary keys here for me and the relationships between the five
> tables? I have tried but always end up with one relation being
> indeterminate.........![/color]


You can't have relationships without attributes. All you have shown
so far are the names of some likely entities.

How about posting a little more of your own effort?

I have all my attributes:

Entrant:

EntrantID
EntrantFname
EntrantSname
etc etc

The one I am struggling with is Results/Events

I really need DFD's to help me throiugh this but I am pretty useless
with them

Any help would be much appreciated


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Brenda,

How about taking a paragraph or two to explain what will be going on at your
gala event and then another paragraph or two to describe what you are trying
to track. Don't assume we know.

As for primary keys, more often than not, I use autonumber keys and never
let another human being see them. If you do any AutoForms or AutoReports
and the autonumber fields are in the generated output, either delete them
and their labels or make them invisible.

I believe that Entrants, Judges and Sponsors could all be Boolean fields in
tblPerson

What are Events?
What are Categories?
What are Results?

So far it looks like a very simple application. Give as much help as you
can and you'll get all the help you need.

FYI: I and many other lurkers of the newsgroups use Outlook or Outlook
Express rather than the internet based tools for reading and posting. With
the internet based tools you usually have the whole thread seamlessly
displayed. For those tools it seems ridiculous and noisy to continually
copy the entire thread. However, with the vagaries of what newsgroups are in
view to the Outlook/Express user, sometimes only parts of threads appear.
Also, we only have one post of the thread open at a time with any
convenience. Therefore it makes sense to always have the entire thread in
each post, possibly with some judicious snipping.

p.s. In the time I've been typing this someone with answers to the
questions above could have provided you with answers to your questions.
:-)

HTH
--
-Larry-
--

"Brenda" <brenda.sendall@ntlworld.com> wrote in message
news:f8fc6bfe.0405090528.5ac76d80@posting.google.c om...[color=blue]
> I have to design a data base for a Gala Event.
>
> I need tables for:
>
> Entrants
> Judges
> Sponsors
> Categories
> Results/Event
>
> I take it the above will be my five tables. Can someone identify the
> primary keys here for me and the relationships between the five
> tables? I have tried but always end up with one relation being
> indeterminate.........!
>
> It is getting very frustrating now
>
> Brenda[/color]

Hi Brenda,

Pardon my being so arbitrary about the Boolean fields. If Entrants, Judges
and Sponsors are mutually exclusive they could be held in a single numeric
field and presented in an Option Group.

--
-Larry-
--

"Larry Daugherty" <larrySpamNotdaugherty@verizon.net> wrote in message
news:vzInc.183784$L31.112407@nwrddc01.gnilink.net. ..[color=blue]
> Hi Brenda,
>
> How about taking a paragraph or two to explain what will be going on at[/color]
your[color=blue]
> gala event and then another paragraph or two to describe what you are[/color]
trying[color=blue]
> to track. Don't assume we know.
>
> As for primary keys, more often than not, I use autonumber keys and never
> let another human being see them. If you do any AutoForms or AutoReports
> and the autonumber fields are in the generated output, either delete them
> and their labels or make them invisible.
>
> I believe that Entrants, Judges and Sponsors could all be Boolean fields[/color]
in[color=blue]
> tblPerson
>
> What are Events?
> What are Categories?
> What are Results?
>
> So far it looks like a very simple application. Give as much help as you
> can and you'll get all the help you need.
>
> FYI: I and many other lurkers of the newsgroups use Outlook or Outlook
> Express rather than the internet based tools for reading and posting.[/color]
With[color=blue]
> the internet based tools you usually have the whole thread seamlessly
> displayed. For those tools it seems ridiculous and noisy to continually
> copy the entire thread. However, with the vagaries of what newsgroups are[/color]
in[color=blue]
> view to the Outlook/Express user, sometimes only parts of threads appear.
> Also, we only have one post of the thread open at a time with any
> convenience. Therefore it makes sense to always have the entire thread[/color]
in[color=blue]
> each post, possibly with some judicious snipping.
>
> p.s. In the time I've been typing this someone with answers to the
> questions above could have provided you with answers to your questions.
> :-)
>
> HTH
> --
> -Larry-
> --
>
> "Brenda" <brenda.sendall@ntlworld.com> wrote in message
> news:f8fc6bfe.0405090528.5ac76d80@posting.google.c om...[color=green]
> > I have to design a data base for a Gala Event.
> >
> > I need tables for:
> >
> > Entrants
> > Judges
> > Sponsors
> > Categories
> > Results/Event
> >
> > I take it the above will be my five tables. Can someone identify the
> > primary keys here for me and the relationships between the five
> > tables? I have tried but always end up with one relation being
> > indeterminate.........!
> >
> > It is getting very frustrating now
> >
> > Brenda[/color]
>
>[/color]