Star Conceptual Data Model for Financial Transaction
This shows a Star Conceptual Model for a Financial Transaction in a Bank.
You can compare this with the corresponding
Physical Data Model or
a Snowflake Design.
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.
