Hi Clifford

I've already identified what I hope is all of the information that we need
to record, and have tentatively set up the required tables, but am having
some trouble visualising it and the relationships, so was wondering whether
anyone ese had den somethign similar an had a workable set up. In particular,
I dont know how I would avoid over-filling the creche and nursery, and how I
would avoid double bookings... do i need a separate table containing dates,
and then link that to the sessions?

"Clifford Bass" wrote:

Hi Carlo,

It is a start. One thing to do is figure out in plain language all of
the information you will need to record. You will also need to figure out
how it all fits together, both from the users functional needs (i.e. what
they do and how they do things) and in the database. Then make the step to
figuring out what tables are needed and what fields go in them. From what
you mention, you are going to set up a number of other tables such as ones to
define the nursery, creche, course information, equipment and so on,
including limits. An you are going to need several more table to hold
registration, session, equipment, catering and other information. When
adding people to courses, the nursery, and so forth, you will need to check
how many are already scheduled for a particular session against the limits.
Or for equipment, if any is available for the session. You've got a big task
ahead of you. So, again, if you have not already done so, you need to do a
thorough analysis of the whole process before getting to the design details.

Hope this helps,

Clifford Bass

"Carlo" wrote:

Hi

We run a community centre which provides training, rooms for events, a
nursery and a creche.

I currently have a database set up as follows:

Child Users - Child User ID
Child Nursery Users - Child User ID
Adult Users - Adult User ID
Adult Nursery Users - Adult User ID
Custodianship - Child USer ID and Adult User ID

This is enough for me to monitr the users of our centre. I now need to set
up a booking system, so that I can book children into the nursery (no more
than 35 at one time), book children ino the creche (no more than 8 at one
time), book adults onto courses (variable limits) and then record their
attendance, and book out our rooms (together with catering and equipment) for
external events.

My main problem is placing limits on the number of people attending at a
given time. Though general suggestions on the structure would be very very
welcome.

Thanks a lot

Carlo