Database Answers Financial Products (Click for Web Site)

Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for our Banking Generic Data Model 
An Access Database is available.

The Specifications for the Model have been derived from our analysis of the Lifecycle of a Trade.

A Data Mart will be designed to analyse Transactions and Cash Flows and track money.
We have also created Data Models for these Investment Banking Subject Areas
that go with this Top-Level Data Model :-
  • Accounts
  • Customers
  • Deals
  • Settlements
  • Staff
    So we need Models for Cashflows and Financial Products.

    The Conceptual Banking Model

    Generic Conceptual Data Model
    Logical Banking Model

    Logical Data Model
    Extract SQL Script for SQL Server
    
    /* ---------------------------------------------------------------------- */
    /* Target DBMS		: MS SQL Server 2008                              */
    /* Author		: Barry Williams                                  */              
    /* Created on:            2016-11-15 14:36                                */
    /* ---------------------------------------------------------------------- */
    /* Tables                                                                 */
    /* ---------------------------------------------------------------------- */
    /* Add table "Customers"                                                  */
    /* ---------------------------------------------------------------------- */
    CREATE TABLE [Customers] (
        [Customer_ID] UNIQUEIDENTIFIER NOT NULL,
        [Personal_Name] VARCHAR(255),
        [Middle_Name] VARCHAR(255),
        [Family_Name] VARCHAR(255),
        [Organisation] VARCHAR(255),
        [Date_of_Birth] DATETIME,
        [Gender_MFU] CHAR(1),
        [Other_Details] VARCHAR(255),
        CONSTRAINT [PK_Customers] PRIMARY KEY ([Customer_ID])
    )
    GO
    /* ---------------------------------------------------------------------- */
    /* Add table "Accounts"                                                   */
    /* ---------------------------------------------------------------------- */
    CREATE TABLE [Accounts] (
        [Activity_ID] VARCHAR(50) NOT NULL,
        [Customer_ID] INTEGER NOT NULL,
        [Activity_Name] VARCHAR(255) NOT NULL,
        [Activity_Description] VARCHAR(255) NOT NULL,
        CONSTRAINT [PK_Accounts] PRIMARY KEY ([Activity_ID])
    )
    GO
    

    Barry Williams
    November 15th. 2016
    Database Answers Ltd.
    London, England



  • © Database Answers Ltd. 2016

    Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map