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   

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.

On May 1st. I decided that the target for my POC was to complete these Cloud Services - Air Transport Platform,  (Azure Demo), Asset Management, Banking, Hotels, Insurance, Logistics,
Removals,Retail Sales, United Nations Global Compact - by the end of May in Microsoft Azure, Oracle Apex, Salesforce or Service Now.
I produced End-to-End Views for these Applications - Air Transport, Assets, Banking, Hotels, Insurance, Removals, Retail Customers and UN Global Compact Platform

My Plans include 6 more - Doctors and Patients, HR, Law Enforcement, Local Government, Logistics and Student Registration

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