Retail Banks Data Model


Printer-friendly version

Careers

3NF Data Warehouse for Retail Banks

You can Email me if you would like an Access Database.
The Requirements have been defined in a question to the Database Answers Web Site.
A Dimensional Data Mart and a Dimensional Model have been designed to provide a starting-point for Enquiries and Reports.

an ERwin 3NF Data Model Has been created, along with along with an ERwin Dimensional Data Mart.

Scroll down to see the three Data Models

You can take a look at two Slide Shows that run less than 2 minutes each.
One is for the Dimensional Models (which runs automatically) and the other is for the Logical (3NF) Data Model, (which also runs automatically, but you can override it)

The Events in the Customer Life Cycle are part of an Agile approach to designing a 3NF Data Model and a Dimensional Data Mart :-

Event 1 - Set-up Banks and Branches

Event 2 - Create new Customer

Event 3 - Setup New Account

Event 4 - Issue Credit Card

Event 5 - Customer makes Deposit

Event 6 - Customer uses Card

Event 7 - Bank Issues Statement

Event 8 - Customer closes Account

An Enterprise Data Model (3rd. Normal Form)	Physical Enterprise Data Model and Data Types
A Dimensional Model
Two Data Marts with Conformed Dimensions