Database Answers Actors Masks
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Operational Support Services for an Airport-in-a-Box 
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.

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

Step 2. This Conceptual Data Model shows our OSS Conceptual Data Model :-

OSS Conceptual Data Model for an Airport-in-a-Box
Step 3. We identify these Subject Areas to help us:-
  • Clients and Service Requests

  • 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 24th. 2014


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