80 likes | 233 Vues
Chiara Braia Patrick Haddad Megan Slocum Mark Visbisky Eunsun Yun. Company Overview. Founded in the winter of 1957-1958 in Ellicottville, NY Started with only four slopes and one T-bar Currently has 10 lifts and 3 high speed quads 58 slopes and trails 3 base lodges 2 hotels
E N D
Chiara Braia Patrick Haddad Megan Slocum Mark Visbisky EunsunYun
Company Overview • Founded in the winter of 1957-1958 in Ellicottville, NY • Started with only four slopes and one T-bar • Currently has 10 lifts and 3 high speed quads • 58 slopes and trails • 3 base lodges • 2 hotels • Golf course • 3 pools • Aerial Park • Mountain Coaster • Sky High Aerial Adventure Park
Problem • Parent’s and children’s information is stored separately, no connection • Current database clears records after each ski season. • Customer had to fill out the same forms at each visit.
Database Design Overview • Three tables • Equipment • Children’s information • Parent (Customer) Information • Reports based on tables • Present information in a fast, easily accessible fashion • Reports • Children • Children by Level • Children’s Equipment • Customer Equipment Registration • Customers • Customers by City • Customer’s Children
User Interface Design • Made with the user in mind • Simple and efficient access to information • Easy to search for customers based on relationships • Connects child’s information to parent’s, vice versa
Business Value • Saves time • Sorting through files • For recurring and new customers • Saves physical space • Less files, no hard copies of records • Promotions • Use information collected to send out to customers • Easier to keep track of who has received promotions
Project Demonstration • We will now present our database.