1 / 6

The treehouse toy store

The treehouse toy store. Scheduling Database. Presented by Emily Baczynski Michael Colafranceschi Anthony Juliano Jihoon Kim Joanne Ye . Project Background. Small, independent toy store in Buffalo, NY Owned by David and Gaetana Schueckler

miette
Download Presentation

The treehouse toy store

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. The treehouse toy store Scheduling Database Presented by Emily Baczynski Michael Colafranceschi Anthony Juliano Jihoon Kim Joanne Ye

  2. Project Background • Small, independent toy store in Buffalo, NY • Owned by David and GaetanaSchueckler • Gaetana in charge of scheduling employees every two weeks • Scheduling is currently a paper based process • Scheduling conflicts often arise • Time off requests often lost • Need for simple computer based aid to ease scheduling process

  3. Database Design • Caters to both the scheduler (Gaetana, the owner) and employees • User has access to either reports menu or form menu • Employee use • Forms to update information • Reports to view schedule • Gaetana use • Forms to schedule employees • Reports to aid scheduling process

  4. Forms • Forms allow employees to enter or update information and make time off requests • Gaetana uses forms to approve time off requests and schedule employees

  5. Reports • Reports quicken scheduling process for Gaetana • Reports give employees quick access to their schedule • Reports • Employee Days Off • Schedule By Date • Schedule By Employee • Weekly Employee Hours • Employees Per Day

  6. Conclusion • Quick access to information • Decreases likelihood of lost information • Makes scheduling process quicker • Easy to make changes • Avoid scheduling conflicts

More Related