1 / 27

Christian Pizzimenti Barbara Korycki Gurtej

Christian Pizzimenti Barbara Korycki Gurtej. As-Is System. Jury-rigged system Various Macintosh-based spreadsheet Word processing Flat File database Problems Data integrity issues Performance issues Loss of business efficiency

pooky
Download Presentation

Christian Pizzimenti Barbara Korycki Gurtej

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. Christian Pizzimenti Barbara Korycki Gurtej

  2. As-Is System Jury-rigged system • Various Macintosh-based spreadsheet • Word processing • Flat File database Problems • Data integrity issues • Performance issues • Loss of business efficiency • Business is expanding quickly and the need for keeping better track of their categories, both subscription and customers

  3. System Request • Upgrade the Jury-rigged system to more efficiently, reliably, and accurately handle the management of Small Byte’s subscriptions

  4. As-Is: Subscription Methodologies Phone Mail Employee Customer Web Gather Information Enter Information into System

  5. As-Is: Packaging Methods Single Copy Renewal Notice Customer Shipper Ship Multiple Copy Plain Vanilla Corporate Multiple people One person Bulk by zip code Issue Type Distributor

  6. As-Is: Issue Types Mini Issue Trial/ Sample Customer Employee Bulk Single Copy First year free Plain Vanilla Corporate Author Editor Multiple Copy Discount Bulk Payment Distributor

  7. Plain Vanilla (single copy) Customer Account Valid? No renewal notice Single copy Yes Corporate Multiple copy One Person Distributors (bulk) Multiple people Renewal notice No Shipper Current Issue Back Issue Issue Ship Single Articles Trial/Sample Mini Issues Send Customer a letter to request payment As-Is: Overall Scheme

  8. To-Be Shipping System • Design and implement a fully functional management subscription system • Software • Visual Basic 6.0 • SQL server database

  9. Linking the shipping to the financial and customer entities • Shipping communicates with the customer database and receives customer shipping information • Shipping also communicates with financial database based and receives only those customers who have paid

  10. Our Work Plan Work Plan Estimated Hours Actual Hours Planning 20 24 Analysis 25 21 Design 30 40 Implementation 20 1) Use-Case Diagrams 2) Interface Design 3) Database Design 4) Programming

  11. Proposed System..

  12. Monthly Cycle • First Week • Shipping monthly issues • Shipping bulk • Second Week • Printing Labels for back issue, mini issue, trial/sample • Third Week • Shipping back issue, mini issue, trial/sample • Fourth Week • Verify Accounts • Printing labels monthly issues and bulk ** Journals need to be printed by the fourth week.

  13. Main Screen - Week 1

  14. Main Screen - Week 2

  15. Plain Vanilla receiving Back Issues

  16. Main Screen - Corporate

  17. Corporate receiving Back Issues

  18. Print Back Issue Labels

  19. Main Screen - Distributors

  20. Main Screen - Week 3

  21. Main Screen - Week 4

  22. Plain Vanilla receiving New Issues

  23. Main Screen - Corporate

  24. Corporate receiving New Issues

  25. Main Screen - Distributors

  26. Distributors receiving New Issues

  27. Call us to install!!!!

More Related