1 / 29

A Billiards Point of Sale Application

A Billiards Point of Sale Application. Christopher Ulmer CS 470 Final Presentation. System Overview. Goal Develop a system that will manage the operation of a billiard hall in an efficient manner Keep a database of all transactions for book-keeping purposes Client is Run-A-Rack Billiards

arleen
Download Presentation

A Billiards Point of Sale Application

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. A Billiards Point of Sale Application Christopher Ulmer CS 470 Final Presentation

  2. System Overview • Goal • Develop a system that will manage the operation of a billiard hall in an efficient manner • Keep a database of all transactions for book-keeping purposes • Client is Run-A-Rack Billiards • Why • The current system is slow • You can only have one module open at a time in the current system

  3. Why does a pool hall need a computer? • Pool tables are not coin operated • The customer rents the table • A computer helps keep track of the status of each table • Not just pool • food, merchandise, bar, etc. • A computer helps track inventory • Book-keeping • A computer can keep exact records of each transaction, daily sales, etc.

  4. Background • I was employed at Run-A-Rack/Hot Shots Billiards in Anchorage from June 1998-July 2002 • I’m very familiar with the current system used • I have based all decisions for this project on my experience as an employee of a pool hall and a customer of various other pool halls

  5. Why I chose this project... • Current system is outdated • Lack of support for the current system • Systems like the one at Run-A-Rack Billiards cost several hundred dollars • Customize

  6. Customize • The new software is customized to fit the needs of Run-A-Rack Billiards • The current software has many features that are not needed • Stubs were left in the code so additional features may be added • Barcode scanner • Cash drawer • Lights

  7. Specifications • Setup • Employee management • Member management • Inventory management • Transaction • Table-Time keeping • Ability to “pause” players

  8. Additional Specifications • Ability to use keyboard only • Easy to back-up

  9. Database • A Microsoft Access database was used to store all information • Pool tables • Members • Employees • Inventory • Transactions

  10. Development Language • Visual Basic 6.0 • The data control was used to connect with Microsoft Access • Small tables • Accessing records from the tables does not take very long (tables are indexed on appropriate fields to allow fast searches) • Ability to create user-friendly interfaces • Time constraints • There was a limited amount of time to finish the project • VB is user-friendly from a programming point of view and provided the tools necessary to finish the project

  11. Development Strategy • Populate the database with test data • Use prototyping to develop and refine each module • Each module is dependent on the database but are independent of each other

  12. System Requirements • Windows 98 or higher • 256 Mb of memory • 266 MHz or higher • 1024 by 768 pixel resolution

  13. System Design • Load most commonly used forms at execution time • Store all information in a single database • Load some table data into arrays • This makes the application run faster • Less time accessing tables

  14. Planning Estimated 130 hours total: Requirements: 6.5 hours Design: 13 hours Implementation: 39 hours Testing: 45.5 hours Write-up: 13 hours Presentation: 13 hours

  15. Time-Keeping Form

  16. Setup

  17. Employee Management Form

  18. Inventory Management Form Simple inventory management form.

  19. Security

  20. Conclusion • Produced a system that will manage the operation of a billiard hall in an efficient manner • Challenges • Put as many features into the software as I could in a limited amount of time • Get my software to work efficiently with the database • Solution • Use prototyping to get an idea of how long each module will take • Use Visual Basic’s data control to access tables and queries

  21. Questions???

  22. Mock-up of Transaction Form

  23. Table Relationship

  24. Setup • Allows user to set pool table pricing and location on the Table-Time keeping form • Limit 99 pool tables • This is so the table can be addressed with a two digit number • Limit 9 players per table • This is so the number of players can be entered by typing one number

  25. Employee Management Form • This is where employee information is held • Personal information • Security information • Employee’s access level • Employees may be added • Employees may be deleted • Employee’s information may be changed at any time by an employee with appropriate authority

  26. Inventory Management Form • Add new items to inventory • Edit information about each item • Code, description, sale price, etc. • Adjust inventory • Add or remove a given amount of an item from inventory. • This can only be opened by an employee with appropriate authority

  27. Transaction Form • This is where purchases are made • A transaction may consist of many items as well as the table cost for players on a given pool table • All transactions will be stored in the database

  28. Table-Time Keeping Form • The Main form • This is displayed most of the time • Shows table layout • Each table image shows the table’s number as well as how many players are currently being charged • Contains commands for opening all other forms

More Related