1 / 12

Presented by Team B

Presented by Team B. Overview of Inventory System for Chocolate Café. By John Leonard, Jamal Matthews, Sandra McMahon. Business Summary. Chocolate Café.

wade-durham
Download Presentation

Presented by Team B

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. Presented by Team B Overview of Inventory System for Chocolate Café By John Leonard, Jamal Matthews, Sandra McMahon

  2. Business Summary Chocolate Café is a small company that provides many types of chocolate to domestic customers. They have been in business for 5 years with a staff of 3 people.

  3. Business Problem • Expanding customer base • Sales are increasing • Current paper system is slow and antiquated • No business reports are performed • Information needs to be saved

  4. Assumptions • Low Employee Staffing • Minimal training • GUI front-end application designed • All data stored in database • All transactions are real-time

  5. Business Rules • Automatic numbering of key Entity ID’s • LOT ID relates to a Product • Special at the product level • Transactions are stored as sales or return • All I/O will be tracked using userid and timestamp for all tables

  6. User Requirements Enhance productivity Easy to use GUI screens Track inventory Generate reports on in-stock inventory Security based transactions

  7. Functional Requirements • User Interface • GUI Screens • Processing • Fast response time • Real Time transactions • Storage • Data stored in database • System Backups • Control • Check, balances, and verification • Reporting • Weekly and Monthly

  8. Use Cases The following use cases were developed to insure correct tracking of inventory in database • Order and receive inventory • Sales and Shipping to Customer • Over the counter sales

  9. Use Cases Diagram

  10. Entities • Manufacturer –Maintains the Chocolate Café’s manufacturer information • Inventory –Maintains the tie of data from the inventory to the manufacturers • Product Type –Contains the actual inventory specifics • Product Lot –This entity is to keep track of product lot data to ensure quality • Transaction –Holds data from every transaction processed • Transaction Type –Retains information on the actual types of transactions • Sales Type –Used to reference the type of sale data to the transaction entity • Security –To enforce user logon security to the database by the employees • Employee –Repository for employee data to track database actions & security

  11. Entity Relationship Diagram

  12. Thank You !!

More Related