Re: Reservation System Design

Gary <gholt_at_nospam.chartermi.net> writes:
> I have posted a similar request on comp.databases.
>
> I need some ideas on a mySQL database design for a reservation system,
> much like a doctor's office (hopefully without the long wait).
>
> My client has 12 work areas. She wants her clients to be able to
> sign up for sessions at these areas on-line. The clients will sign
> up for either 1.5 or 2 hours, and she only wants 4 people to be able
> to start every half hour.

i have recollections of somebody trying to write a calender/scheduling application in the early 80s ... for the conference rooms in bldg. 28 (before research moved up the hill to the new almaden bldg). possibly somebody in the R-star group ... aka the original relational/sql system/r project http://www.garlic.com/~lynn/subtopic.html#systemr

had evolved into r-star by that time ... then i think star-burst followed r-star.

in any case, it wasn't pretty.

-- 
Anne & Lynn Wheeler | http://www.garlic.com/~lynn/