a billiards point of sale application l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
A Billiards Point of Sale Application PowerPoint Presentation
Download Presentation
A Billiards Point of Sale Application

Loading in 2 Seconds...

play fullscreen
1 / 29

A Billiards Point of Sale Application - PowerPoint PPT Presentation


  • 218 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'A Billiards Point of Sale Application' - arleen


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
a billiards point of sale application

A Billiards Point of Sale Application

Christopher Ulmer

CS 470

Final Presentation

system overview
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
why does a pool hall need a computer
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.
background
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
why i chose this project
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
customize
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
specifications
Specifications
  • Setup
  • Employee management
  • Member management
  • Inventory management
  • Transaction
  • Table-Time keeping
    • Ability to “pause” players
additional specifications
Additional Specifications
  • Ability to use keyboard only
  • Easy to back-up
database
Database
  • A Microsoft Access database was used to store all information
    • Pool tables
    • Members
    • Employees
    • Inventory
    • Transactions
development language
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
development strategy
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
system requirements
System Requirements
  • Windows 98 or higher
  • 256 Mb of memory
  • 266 MHz or higher
  • 1024 by 768 pixel resolution
system design
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
planning
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

inventory management form
Inventory Management Form

Simple inventory management form.

conclusion
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
setup25
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
employee management form26
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
inventory management form27
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
transaction form
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
table time keeping form
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