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 ...
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
Payments and Events
Payments Subject Area
Step 6. Then we create this Model from the Subject Areas...
Workspace is A13674, user email@example.com, with m123.
Data loaded so far includes :-
Flight Details, including Landing Intervals
Master Data, including Airlines and Airports.
Database Answers Ltd.
May 24th. 2014
© DataBase Answers Ltd. 2014