A Billiards Point of Sale Application

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
• Im 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 Basics data control to access tables
  and queries

21
Questions???
22
(No Transcript)
23
Mock-up of Transaction Form
24
Table Relationship
25
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

26
Employee Management Form

• This is where employee information is held
• Personal information
• Security information
• Employees access level
• Employees may be added
• Employees may be deleted
• Employees information may be changed at any time
  by an employee with appropriate authority

27
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

28
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

29
Table-Time Keeping Form

• The Main form
• This is displayed most of the time
• Shows table layout
• Each table image shows the tables number as well
  as how many players are currently being charged
• Contains commands for opening all other forms