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 Organisations (part of Apex Operational Support Services) 
An Access Database is available on demand.
Apex is underneath, 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.

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 3 :-
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 1. The starting-point is our Canonical Data Model ...


Step 2. This Conceptual Data Model
shows how it applies to Professional Services :-

Conceptual Data Model for DBA Professional Services
Step 3. We identify these Subject Areas to help us:-
  • Clients and Service Requests
  • Documents

  • Step 4. 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.
  • Step 5. We identify these Subject Areas to help us:-
  • Clients and Fees
  • Customers and Events
  • Documents
  • Payments and Events
  • Payments Subject Area
  • Staff
  • Suppliers
  • Step 6. Then we create this Model from the Subject Areas...

    Logical Data Model for DBA Packaged 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
    May 29th. 2014


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