RE: How to biuld a coursescheduling database

I don't think you should be afraid of changing the table structure if the
change results in a better design. I change the table structure of existing
databases all the time, its totally transparent to the users. It sounds like
you might have made the classic mistake of designing the database to attack
the immediate problem at hand without thinking ahead about how your database
may handle future needs.

You are now left with the problem of where to put the teacher data and the
other attributes of the course sessions. They really belong in a separate
table but you already have the course date in your existing table. If you
don't change the table structure, you will be left with a mess.

Dorian

"Phil" wrote:

> Hi Dorian
>
> thanks for your speedy reply my courses table currently holds the dates of
> the course and start stop times of the course and locations and i cannot
> change that without changing the structure of the rest of the database i also
> dont think i need to change this as the venue will not change for the course.
>
> thanks for giving me a table structure
>
> i will need some logic, however i only ever run one course on one day so
> doublebooking will never occur.
>
> thanks again
>
> Phil
>
>
>
> "mscertified" wrote:
>
> > I would think your course table should not include the date and location.
> > You need these tables:
> >
> > Courses - list of courses
> > Locations - list of course locations
> > Teachers - list of course teachers
> > Sessions - course sessions
> >
> > The Sessions table contains links to course, location and teacher and has
> > the date and time.
> > I don't know what you mean by 'time of break'.
> > Your report would run off of the Sessions table sorted by date and time.
> >
> > If you are using this as a session planning tool, you will need logic to
> > make sure the same teacher does not have conflicting times on different
> > courses or that given locations are not double-booked with courses.
> >
> > Dorian
> >
> >
> > "Phil" wrote:
> >
> > > Hi Everyone
> > >
> > > thanks for all the help i have had so far.
> > >
> > > as i have mentioned before i have a event management database which with all
> > > the help i have had here now works wonderfully. i am now going to try and be
> > > ambitious and plan to add more functionality to the database. i would like
> > > to be able to manage my course timetables through the same database being
> > > able to input sessions that would be run where and when. i am in the very
> > > basic stages of this and would like some assistance for what my table
> > > structure would be like
> > >
> > > i would basically want to be able to print off reports that look like a
> > > timetable for the day
> > >
> > > i already have an events table in my database and would be able to get info on
> > >
> > > course
> > > date
> > > location
> > >
> > > from that table the problem i have is what other atbles do i need
> > >
> > > on the report i need
> > >
> > > time of session
> > > time of break (could just be a session)
> > > type of session (e.g what is chemo, what is radiotherapy what is cancer)
> > > teacher (who is doing the session) different people will do the same sessions
> > >
> > > I will give the time to the session i just need it to be organised on the
> > > report
> > >
> > > i hope someone can help, i looked at Duanes surgery planner but could not
> > > understand how i could adapt it so gave up
> > >
> > > thanks
> > >
> > > Phil
.

Relevant Pages

  • RE: How to biuld a coursescheduling database
    ... > the immediate problem at hand without thinking ahead about how your database ... > other attributes of the course sessions. ... >> Hi Dorian ... >>> The Sessions table contains links to course, location and teacher and has ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Combining tables from two copies of DB
    ... I agree that the challenge with the other database is the junction table. ... linked to the Sessions table through a foreign key field. ... the employee names. ... >> in many training sessions, and each training session may be attended by ...
    (microsoft.public.access.queries)
  • Re: how data from database passed to the session in a loop?
    ... all data is filled in using sessions. ... the data will be populated from the database. ... I wonder if there is a quicker way to do it, like using a loop. ... Jerry Stuckle ...
    (comp.lang.php)
  • Re: how data from database passed to the session in a loop?
    ... When user logs in, all data is filled in using sessions. ... the data will be populated from the database. ... I wonder if there is a quicker way to do it, like using a loop. ...
    (comp.lang.php)
  • Re: Limit FORM mailer submissions to 5 on website, then pause until reviewed by webmaster
    ... have a script that creates a temporary row in a sessions table as soon ... then don't display the input form and instead display the message, ... You wouldn't lock the file from the time they come to the page until ... the database occurs, ...
    (comp.lang.perl.misc)
Quantcast