1. MGS 351 Camp Project Anthony Rizzi Jared Eder Michael O'Leary Phuong Viet Vu TianLan

2. Introduction • Background of project • Business problem/opportunity • Identification of business value • Database design overview • Project demonstration • Conclusion

3. Background • Spring lake summer camp company • Eight weeks each summer • Massive information of Campers, Guardians and Employees • Keep track and real time process information • Groups are paired with specific counselor

4. Business Problem/Opportunity • No existing database system • Poorly paper driven system • Too much human resource and materials • Demand for efficiency and reliability • Scientific management system

5. Identification of Business Value • Paperless and painless • Keep track of organization’s financial • Better management inside camp • Maintain the solid relationship with customers

6. Database Design Overview • Entity Relationship Diagram

7. Database Design Overview • Five tables and reports • Campers Emergency Contact Information • Campers that have Allergies • Campers that Owe Money • Employees by Jobs • Grouped locations • Two Queries • Allergy • Who has not paid • Seven Forms

8. Project Demonstration The link of project website and database

9. Conclusion • Goals of building this system • Meet all the needs • Created the substantial business value

10. Questions ?