Database Answers Header Kasbah du Toubkal Hotel, Morocco
Casinos
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  
A Snowflake/Star Schema (Dezign) Data Model is shown below.
It has a Snowflake extension to a basic Star Schema because of the many-to-many between Slots and Groups.
The design shown on this page assumes that a 'Not Applicable' NULL Group is defined so that every Slot Machine belongs to at least one Group.
Here is an alternative design without the existence of a NULL Group.
This has two benefits :-
  1. It conforms to the common approach for Data Warehouse designs.
  2. It simplifies the specification of queries.
A Star Schema Dezign Data Model for Casinos

Barry Williams
Principal Consultant
Database Answers
1st. December 2002


[ Home Page | Ask Us a Question | Email Us | Site Map ]

© IceBreaker WebDesigns 2002