A%20Billiards%20Point%20of%20Sale%20Application - PowerPoint PPT Presentation

About This Presentation
Title:

A%20Billiards%20Point%20of%20Sale%20Application

Description:

Ability to create user-friendly interfaces. Time constraints ... VB is user-friendly from a programming point of view and provided the tools ... – PowerPoint PPT presentation

Number of Views:47
Avg rating:3.0/5.0
Slides: 30
Provided by: and8150
Category:

less

Transcript and Presenter's Notes

Title: A%20Billiards%20Point%20of%20Sale%20Application


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
Write a Comment
User Comments (0)
About PowerShow.com