|
|
|
|
|
|
|
|
|
|
|
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 | ||