Database Answers Capitol Hill in Washington DC
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for the US Presidential Transition 2017   
We would be glad to have your comments.

I am currently building a working version in Oracle Apex.
If you would like to be involved, just ask us.

Wikipedia has an interesting entry on the US Presidential Transition and this one on the Inauguration of Donald Trump.
This builds on our work on User-defined Hierarchies which we use as a Design Pattern.
This shows how powerful an Entity-Relationalship-Design can be.


Step 1. Define a General Conceptual Data Model This shows two Entities that allow us to store Entries in a Hierarchy and define flexible ways they can be Related. Conceptual Data Model

Step 2. Specific Conceptual Data Model Now we refine the structure to reflect the Incoming and Outgoing Herarchies in the Transition. Conceptual Data Model Specific

Step 3. Specific ERD Logical Data Model This shows the basic Database. Logical Data Model

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
November 17th. 2016


© Database Answers Ltd. 2016
About Us Contact Us