473,321 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

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
Nov 12 '05 #1
4 1471
rkc

"Brenda" <br************@ntlworld.com> wrote in message
news:f8**************************@posting.google.c om...
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.........!

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?


Nov 12 '05 #2

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!
Nov 12 '05 #3
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" <br************@ntlworld.com> wrote in message
news:f8**************************@posting.google.c om...
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

Nov 12 '05 #4
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" <la*******************@verizon.net> wrote in message
news:vz*********************@nwrddc01.gnilink.net. ..
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" <br************@ntlworld.com> wrote in message
news:f8**************************@posting.google.c om...
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


Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Cherrish Vaidiyan | last post by:
sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : ...
6
by: Marvin Libson | last post by:
Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database...
8
by: Kamlesh | last post by:
Hi, How do I know the physical database path of a database. When I goto the DB2INSTANCE users's directory (/home/db2inst1), I see following folders: /db2inst1/NODE0000/SQL00001...
1
by: pintur | last post by:
The message is: SQL1036C Errore di I/O durante l' accesso al database. SQLSTATE=58030 what is the proble? what for restore tables? thanks
0
by: Brenda | last post by:
I have to design a data base for a Gala Event. I need tables for: Entrants Judges Sponsors Categories Results/Event
3
by: josh.kuo | last post by:
Sorry about the subject, I can't think of a better one. I recently wrote some PHP classes that I think might be of interest to this group. Since I have been reaping the benefits of reading news...
8
by: morleyc | last post by:
Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well....
0
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: Winder | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.