Database Answers Header

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.
    [ Home Page | Ask me a Question | Email | FAQs | History of Databases | Useful Links ]

    © IceBreaker WebDesigns 2001