Database Answers Actors Masks
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Professional Services with Third Generation Platforms 
An Access Database is available on demand.
Wikipedia says 'The Third Platform is defined as the inter-dependencies
between mobile computing, social media, cloud computing, and information / analytics (big data) and possibly the Internet of Things.
Gartner claims that these interdependent trends are "transforming the way people and businesses relate to technology".
Our Apex implementation of Professional Services is shown below, and the Specifications have been determined in discussion with Subject Matter EXperts (SMEs).

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
There might also be a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.
This shows how Entity Mapping to our Canonical Model and BI on the Beach.

Step 1) The starting-point is our Canonical Data Model


Step 2) Then we design the Conceptual Data Model
Shows how it applies to Professional Services

Conceptual Data Model for Professional Services
Step 3) Finally here is our 3rd Generation Platform for Professional Services...

Step 4. We identify these Subject Areas to help us:-
  • Clients and Fees
  • Customers and Events
  • Documents
  • Payments and Events
  • Payments Subject Area
  • Staff
  • Suppliers



  • Apex Professional Services Demo Step 1 :-

    Apex Infrastructure Professional Services

    Apex Professional Services Demo Step 2 :-
    Click to add this record ...

    Apex Infrastructure Professional Services

    Apex Professional Services Demo Step 31111 :-
    The last record flashes in Red ...

    Apex Infrastructure Professional Services

    Apex Professional Services Demo Step 4 :-

    Apex Infrastructure Professional Services

    Apex Professional Services Demo Step 5 :-
    Adding the last record triggers a message on the Mobile phone :-

    Apex Infrastructure Professional Services



    Step 4. We identify these Subject Areas to help us:-
  • Clients and Service Requests
  • Documents

  • Clients and Fees
  • Customers and Events
  • Documents
  • Payments and Events
  • Payments Subject Area
  • Staff
  • Suppliers
  • Documents
  • Payments and Events
  • Payments Subject Area
  • Staff
  • Suppliers
  • Step 5. Then we plan for Phase 1 - "Service Requests" with these Entities ...
  • Documents
  • Events
  • Offices
  • Services
  • Service Requests
  • Staff
  • Suppliers
  • Master Data includes :-
  • Clients, Services, Staff, Suppliers.
  • Reference Data includes :-
  • Types of Documents, Events and Services.
  • Max Workspace
    Workspace is A13674, user baryw@dba.org, with m123.

    Data loaded so far includes :-
    Flight Details, including Landing Intervals
    Master Data, including Airlines and Airports.
    Ref_Airline_Codes
    Ref_Airport_Codes

    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    July 3rd. 2016


    © Database Answers Ltd. 2016
    Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map