GORP Room checkouts web application
The GORP room checks in and out outdoor recreation equipment such as tents,
sleeping bags, etc. Currently, each person checking equipment out fills
out a paper form with information like name and p-card number, as well as
quantities of equipment (the actual form is available). When the equipment
is returned, this form is filed away. The primary rationale behind making
a web application for these forms is that it would save paper as well as be
easier to organize later on, and checking in and out equipment is a perfect
application for databases.
Requirements
-
The form elements will include exactly those on the current paper form,
probably with similar layout.
-
Each piece of equipment would be listed in an equipment table, where we
would store the type of equipment (ie "two-person tent") and its
replacement cost, as well as room for a comment (ie "missing tent stakes").
-
The equipment would be displayed on the form with text boxes to enter the
quantity being checked out.
-
People checking out equipment will also be able to check out specialized
equipment that is not on the form/in the equipment table (ie "fishing rod"
or "big spoon"). These items need not be added to the equipment table,
but must be displayed. This could possibly be done by adding an equipment
item "Other" with a comment describing the equipment.
-
Names of people checking equipment out need not be stored in a table; it
can just be a field.
-
The application should be able to keep track of late fees according to the
due date for the item and equipment charges for damaged or lost equipment.
For each weekday late the person is charged $2. The damage charges should
be entered manually by the GORP room worker, but the replacement fees for
each item (according to the equipment table) should be able to be looked up
by the worker, probably on a separate page.
-
With these fees, there should be a table that stores the person's info and
the fee.
Administration Features
-
An administrator should be able to add, modify, or delete items on the
inventory list.
-
One might speculate that an administrator would need
some reports of what equipment is checked out, what is
available, what fees are pending, etc. The designers will need
to consider who should be able to see what information regarding
fees, but that likely should not be generally public.
Optional Features
-
These items could potentially be updateable. For instance, if someone
comes in and has an existing checkout and wants to add to it. However,
this may be unnecessary.
-
User authentication (for the GORP room worker) is most likely unnecessary,
but if there is extra time it couldn't hurt.
