1 / 10

MGS 351 Camp Project

MGS 351 Camp Project. Anthony Rizzi Jared Eder Michael O'Leary Phuong Viet Vu Tian Lan. Introduction. Background of project Business problem/opportunity I dentification of business value Database design overview Project demonstration Conclusion. Background.

elda
Download Presentation

MGS 351 Camp Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 ?

More Related