Database Project: Project Proposal and Design
TA: Ian Fineberg
Recitation: A10, Thursday 5pm 146 Park
Group 4 Members: Katherine He, Kyle McJury, Anastasia Mosher-Glenski,
Candice Osborne, Stacy Stern
Pierce Country Day Camp, located in Roslyn, New York, was established in 1918 as one
of America’s first day camps for children. Pierce is a day camp for children ages 5-13 where
children can engage in sports, arts and crafts, aquatics and adventure activities. Throughout the
summer, campers are able to learn, play and engage themselves in numerous events to have lots
of fun. The Pierce experience promotes fun, friendship, and growth for all its campers and staff
members. Maintaining strong values and a diverse program, every camper is able to have an
enjoyable and exciting summer.
The proposed database for Pierce Country Day Camp will create an organized, user
friendly system to keep track of camper allergies and medications. The database will be
available 24/7 to prevent and resolve allergic reactions that occur on campus. Knowing ahead of
time of campers allergies will hopefully prevent the occurrence of an allergic reaction. If an
allergic reaction does occur, Pierce Country Day Camp with be able to quickly access the
information to assist the camper with their condition.
Stacy Stern is the business expert of Pierce Country Day Camp. As a counselor for two
consecutive summers, she is well aware of the environment and conditions of the camp.
Experiencing many unfortunate emergency situations due to allergic reactions, she feels that a
database will prevent emergency situations, promote a safer environment, and organize the files
of Pierce Country Day Camp.
The instillation of the database will promote a safer environment at Pierce Country Day
Camp. This database will not only put many of the parents mind at ease knowing the camp is
increasing safety precautions with this database, it will also result in the children’s safer and
longer experience at Pierce. The basic bottom line for this new data base is for the campers to
enjoy the camping experience and to stay as long as possible. The more summers the campers
come back to stay at Pierce, the more the parents will pay, and this will result in more revenue
Asides from safety and prevention of allergic reactions, the database will help solve
business problems such as time and organization. The purpose is to provide more efficiency for
the staff in case of emergency circumstances. The database will give the day camp the
opportunity to prevent allergic reactions, reduce the risk of serious medical conditions arising,
and decrease chaos if an emergency does arise in a timely manner. The database will solve
problems such as a lack of awareness of the children’s medical conditions/allergies and impose a
more organized system to treat and deal with the situation in case an emergency situation occurs.
The database will contain all the needed information for each camper. Every staff
member will be advised and taught how to operate the database. The functions that the database
will perform include the illustration of a child’s allergies, medical conditions, and emergency
contacts. The main users of the system will include all camp staff members. This system will be
used to access information in a timely manner in order to provide a safer environment for
children attending day camp.
As time progresses, Camp Pierce would like to expand their database. We are
looking to include a schedule/calendar for each age group and the activities they will be
participating in daily. In addition to these daily events, we plan to post a menu of food that the
campers will be able to choose from. Hopefully, these menu postings can prevent future allergic
reactions. Also, we would like to post financial transactions by the parents to keep a better record
of receipts and allow this to be available to all the counselors.