Re: Reservation System Design
Date: Wed, 07 Dec 2005 10:43:00 -0700
Message-ID: <m3hd9k4xcr.fsf_at_lhwlinux.garlic.com>
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/Received on Wed Dec 07 2005 - 18:43:00 CET