Events with workshops

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.

Relevant Pages

  • =?ISO-8859-1?Q?Irish_Music_Weekend=2C_St=2ELouis_Tion=F3l=2C__April_4=2C_5=2C_?= =?ISO-8
    ...   All instruments and skill levels are welcome! ... Here's a list of the workshops and teachers. ... afternoon workshop sessions with a lunch break in between. ... out around the grounds a bit too, and some play in the gazebo or the ...
    (rec.music.makers.guitar.acoustic)
  • Re: International QL & Mac are 25 event will b e hosted in Lucerne, Switzerland on Sat/Sun Oct 3
    ... with agenda, sessions, exhibition list and FAQ. ... 32 beautiful places (mount Pilatus, famous KKL concert hall, lake ... Sessions and workshops will cover past, ...
    (comp.sys.sinclair)
  • Re: Events with workshops
    ... Thanks for your reply, you have it correct with the workshops, although the ... Lung cancer ... and that Attendees are registering for Workshops rather than ... tables for Workshops, sessions. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Events with workshops
    ... Workshops, and that Attendees are registering for Workshops rather than ... tables for Workshops, sessions. ...
    (microsoft.public.access.tablesdbdesign)
  • IT Security World 2005 ???
    ... Has anyone been to to the IT Security World 2005 < ... How good are the sessions ... I have been to some workshops in the past ... but informed dictatorship is better. ...
    (Security-Basics)