Database Answers Old Locks and Keys (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 the POC Projects   
3rd. Party Payment Engines -
  • Braintree (a Paypal company), Foxy Cart , and Paypal
    Click here for the Specification of all Events for each Platform.
    In the Logical Data Model we have a Circle symbol that shows an Inheritance Relationship we define a Parent Customer with a number of Children Customers.
    Each of the Children inherits all the charactistics of the Parent and has some additional charactistics of its own.

    By July 4th. I had made good progress on Proof-of-Concepts using Oracle Apex for these Cloud Services - Agents, Banking, Customer Data Platform, Facilities,
    Hotels, HR, Insurance, Payments, Removals, Reservations, Retail Sales, Student Registration, Supply Chains and Utility Bills
    I produced End-to-End Views for these Applications - Air Transport and Assets,

    My POC Plans include these - Asset Management, Doctors and Patients, Law Enforcement, Local Government, Logistics and United Nations Global Compact.

    Conceptual POC Events and Sub-Types Data Model

    Data Model for the POC Project
    Logical POC Events Data Model

    Data Model for the POC Project
    Conceptual Customers Data Model

    Data Model for the POC Project
    Logical Customers Data Model

    Data Model for the POC Project
    Conceptual version of Our Canonical Data Model


    Canonical Data Model
    Physical Data Model
    Here we show how we implement Inheritance in a Relational Database.

    Physical Data Model
    Events Logical Data Model with Inheritance
    Here we can see that each Sub-Type can have its own Attributes.

    Our "Participants" ERwin Canonical Data Model
    This is a little different from the Conceptual version

    ERwin Canonical Data Model


    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    May 20th. 2017


  • © Database Answers Ltd. 2017
    About Us Contact Us