|
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 :-
|
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...
|
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
|