Database Answers A Successful Pool Hall
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Pool Hall Management   
An Access Database is available on demand.
The Requirements have been determined by experience and insight.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

There is also a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.

Conceptual Data Model

Conceptual Data Model for Pool Hall Management
Entity-Relationship Diagram (ERD Data Model)

Data Model for Pool Hall Management

This is the Top-Level Data Model and separate Models have been created for each Step :-
  • 1) Customers
  • 2) Tables and Bookings
  • 3) Cash Payments
  • 4) Regular Bookings
  • 5) Generic Customers
  • 6) Parties
  • 7) Reference Data
  • 8a) Complete Model
  • 8b) Complete Model - showing Keys only
  • 8c) Complete Model - showing Entity names only

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    August 27th. 2010

  • © DataBase Answers Ltd. 2010
    About Us Contact Us