|
|
|
Conceptual Star Data Model for Teaching Schedule
|
You can check out the FACTs or Business Rules which the Data Model must comply with,
and a Physical Data Model has been produced.
Star and Snowflake Data Models are typically used to support Data Warehouses
or Data Marts.
These designs are characterised by a central Table, holding the 'FACTS',
with a number of 'DIMENSIONS' tables radiating outwards, just to one level.
A Snowflake Design is similar, except that there are many levels radiating outwards.
A Star Design is often a de-normalised Snowflake and is preferred for performance reasons,
which can be a critical issue in Data Warehouses.
Barry Williams
Principal Consultant
Database Answers
