Database Answers Header Las Vegas Casinos (Click for de Louise Web Site)
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
A. The Area being Modelled is :-
A Data Warehouse for Slot Machines in a Casino.

B. The Things of Interest, ('THINGS'), include :-
B.1 Groups of Slot Machines
B.2 Slot Machines
B.3 Takings

C. These THINGS are Related as follows :-
C.1 A SLOT_MACHINE can be in zero, one or many GROUPS_OF_SLOT_MACHINES.
C.2 TAKINGS are removed from the Slots at specific Time Periods.

D. Other Characteristics of these THINGS include :-
D.1 A SLOT_MACHINE can be in one and only one LOCATION.

E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-
F.1 What were the Total Takings for slot Machines in Group 1 yesterday ?

Barry Williams
Principal Consultant
Database Answers
1st. December 2002
[ Home Page | Ask Us a Question | Email Us | Site Map ]

© 2002