A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Events with workshops



 
 
Thread Tools Display Modes
  #1  
Old February 3rd, 2009, 04:38 PM posted to microsoft.public.access.tablesdbdesign
Phil
external usenet poster
 
Posts: 606
Default Events with workshops

I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops, normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or none at
all. I have no idea how to design the table structure, do I need seperate
tables for Workshops, sessions. Any advice would be greatly accepted. If
you need any more info let me know

Thanks

Phil
  #2  
Old February 3rd, 2009, 05:53 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Events with workshops

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather than
Events.

If you add a Workshop table, then use WorkshopID in your trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" wrote in message
...
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or none
at
all. I have no idea how to design the table structure, do I need seperate
tables for Workshops, sessions. Any advice would be greatly accepted. If
you need any more info let me know

Thanks

Phil



  #3  
Old February 4th, 2009, 10:10 AM posted to microsoft.public.access.tablesdbdesign
Phil
external usenet poster
 
Posts: 606
Default Events with workshops

Hi Jeff

Thanks for your reply, you have it correct with the workshops, although the
attendees are first registered on an event and then chose which workshop they
want to attend. I have added a workshop table and did use a field in the
registration table to store what workshop they want, the problem is that
means they can only have one workshop for each course (unless I am missing
something as they only have one registration record for each course). The
other issue I have is that if an event has two workshops they may be
different workshops

e.g
am
Lung cancer
clorectal cancer

pm
breast cancer
kidney cancer

how do i account for that?

Hope you can help

Phil

"Jeff Boyce" wrote:

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather than
Events.

If you add a Workshop table, then use WorkshopID in your trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" wrote in message
...
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or none
at
all. I have no idea how to design the table structure, do I need seperate
tables for Workshops, sessions. Any advice would be greatly accepted. If
you need any more info let me know

Thanks

Phil




  #4  
Old February 4th, 2009, 05:22 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Events with workshops

Phil

We might be focusing to narrowly on 'tables' and not enough on the entities
and relationships. The tables will follow if you've laid out (usually
pencil/paper) the entity/relationship diagrams.

It sounds like you are saying:
* one person can register for one-to-many events
* one event can have one-to-many workshops
* one workshop can have one-to-many topics
* one person can register for one-to-many topics

Does this match your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" wrote in message
...
Hi Jeff

Thanks for your reply, you have it correct with the workshops, although
the
attendees are first registered on an event and then chose which workshop
they
want to attend. I have added a workshop table and did use a field in the
registration table to store what workshop they want, the problem is that
means they can only have one workshop for each course (unless I am missing
something as they only have one registration record for each course). The
other issue I have is that if an event has two workshops they may be
different workshops

e.g
am
Lung cancer
clorectal cancer

pm
breast cancer
kidney cancer

how do i account for that?

Hope you can help

Phil

"Jeff Boyce" wrote:

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather than
Events.

If you add a Workshop table, then use WorkshopID in your trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" wrote in message
...
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or
none
at
all. I have no idea how to design the table structure, do I need
seperate
tables for Workshops, sessions. Any advice would be greatly accepted.
If
you need any more info let me know

Thanks

Phil






  #5  
Old February 5th, 2009, 05:12 PM posted to microsoft.public.access.tablesdbdesign
Phil
external usenet poster
 
Posts: 606
Default Events with workshops

Yes thats right, my existing database already handle bookings for multiple
events, I am really struggling to add workshops to it, I thought I had it
until we ran an event with two workshops

Thanks

Phil

"Jeff Boyce" wrote:

Phil

We might be focusing to narrowly on 'tables' and not enough on the entities
and relationships. The tables will follow if you've laid out (usually
pencil/paper) the entity/relationship diagrams.

It sounds like you are saying:
* one person can register for one-to-many events
* one event can have one-to-many workshops
* one workshop can have one-to-many topics
* one person can register for one-to-many topics

Does this match your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" wrote in message
...
Hi Jeff

Thanks for your reply, you have it correct with the workshops, although
the
attendees are first registered on an event and then chose which workshop
they
want to attend. I have added a workshop table and did use a field in the
registration table to store what workshop they want, the problem is that
means they can only have one workshop for each course (unless I am missing
something as they only have one registration record for each course). The
other issue I have is that if an event has two workshops they may be
different workshops

e.g
am
Lung cancer
clorectal cancer

pm
breast cancer
kidney cancer

how do i account for that?

Hope you can help

Phil

"Jeff Boyce" wrote:

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather than
Events.

If you add a Workshop table, then use WorkshopID in your trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" wrote in message
...
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or
none
at
all. I have no idea how to design the table structure, do I need
seperate
tables for Workshops, sessions. Any advice would be greatly accepted.
If
you need any more info let me know

Thanks

Phil






  #6  
Old February 5th, 2009, 05:46 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Events with workshops

If my proposed description matches what you are working with, then you'll
want to consider a table structure that allows for each of those entities
(person, event, workshop, topic) AND another table (or more than one) that
lets you relate these (e.g., Registration).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" wrote in message
news
Yes thats right, my existing database already handle bookings for multiple
events, I am really struggling to add workshops to it, I thought I had it
until we ran an event with two workshops

Thanks

Phil

"Jeff Boyce" wrote:

Phil

We might be focusing to narrowly on 'tables' and not enough on the
entities
and relationships. The tables will follow if you've laid out (usually
pencil/paper) the entity/relationship diagrams.

It sounds like you are saying:
* one person can register for one-to-many events
* one event can have one-to-many workshops
* one workshop can have one-to-many topics
* one person can register for one-to-many topics

Does this match your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" wrote in message
...
Hi Jeff

Thanks for your reply, you have it correct with the workshops, although
the
attendees are first registered on an event and then chose which
workshop
they
want to attend. I have added a workshop table and did use a field in
the
registration table to store what workshop they want, the problem is
that
means they can only have one workshop for each course (unless I am
missing
something as they only have one registration record for each course).
The
other issue I have is that if an event has two workshops they may be
different workshops

e.g
am
Lung cancer
clorectal cancer

pm
breast cancer
kidney cancer

how do i account for that?

Hope you can help

Phil

"Jeff Boyce" wrote:

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather
than
Events.

If you add a Workshop table, then use WorkshopID in your
trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" wrote in message
...
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the
sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or
none
at
all. I have no idea how to design the table structure, do I need
seperate
tables for Workshops, sessions. Any advice would be greatly
accepted.
If
you need any more info let me know

Thanks

Phil








  #7  
Old February 6th, 2009, 10:51 AM posted to microsoft.public.access.tablesdbdesign
Phil
external usenet poster
 
Posts: 606
Default Events with workshops

Jeff

Thanks again for your help, please correct me if I am wrong but I think you
might have relesaed my brain block. I already have Attendees, Registration,
Events, tables,
If I had a workshops table, and topics table along with a Workshops
registration table to allow registration of Attendees to a workshop, I think
I can see how this can work (I have a diagram in front of me that looks like
it will work). Thanks

Phil
"Phil" wrote:

Yes thats right, my existing database already handle bookings for multiple
events, I am really struggling to add workshops to it, I thought I had it
until we ran an event with two workshops

Thanks

Phil

"Jeff Boyce" wrote:

Phil

We might be focusing to narrowly on 'tables' and not enough on the entities
and relationships. The tables will follow if you've laid out (usually
pencil/paper) the entity/relationship diagrams.

It sounds like you are saying:
* one person can register for one-to-many events
* one event can have one-to-many workshops
* one workshop can have one-to-many topics
* one person can register for one-to-many topics

Does this match your situation?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Phil" wrote in message
...
Hi Jeff

Thanks for your reply, you have it correct with the workshops, although
the
attendees are first registered on an event and then chose which workshop
they
want to attend. I have added a workshop table and did use a field in the
registration table to store what workshop they want, the problem is that
means they can only have one workshop for each course (unless I am missing
something as they only have one registration record for each course). The
other issue I have is that if an event has two workshops they may be
different workshops

e.g
am
Lung cancer
clorectal cancer

pm
breast cancer
kidney cancer

how do i account for that?

Hope you can help

Phil

"Jeff Boyce" wrote:

Phil

It sounds like you are saying one Event can have zero, one, or many
Workshops, and that Attendees are registering for Workshops rather than
Events.

If you add a Workshop table, then use WorkshopID in your trelRegistration
table, would that do it?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Phil" wrote in message
...
I have an events database that I now need to add workshops, the basic
structure of the tables is

Events:
---------
EventID

Attendee:
-------------
AttendeeID

Registration:
--------------
RegistrationID
EventID
AttendeeId

the real world situation is that some events we run have workshops,
normally
the group will split into smaller groups and attend one of the sessions

e.g.
Bereavment
MCA
Cancer

Each event may have more than one workshop in a day, one workshop or
none
at
all. I have no idea how to design the table structure, do I need
seperate
tables for Workshops, sessions. Any advice would be greatly accepted.
If
you need any more info let me know

Thanks

Phil






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.