Data Model for Asset Management
Back to the Home Page
Our Asset Management Service is primarily planned for Removals and Utilities including Electricity, Gas, Water and Transport, such as Airport, and Rail.


Step 1a - Define POC Conceptual Data Model


Step 1b Define MVC Conceptual Data Model


Step 2 - Here we show the MVC Component (Model) with
the associated Web Service.
Model - Add a new Asset (Create a Record)
Model - Add Payment (Update a Record)
Model - Move an ASset (Update a Record)
Model - Pay a Bill (Update a Record)
Model - Remove an Asset (Update a Record)

Step 1c - Define POC Logical Data Model Aug28th.

Step 2 - Define POC Logical Data Model

Step 3 - Define POC Physical Data Model
Maybe Primarily Domestic Items

Step 4 - Asset Register Logical Data Model
Corresponding Tables

Getting Started Conceptual Data Model for Asset Management
Step 5 - Asset Register Physical Data Model

Physical Data Model for Asset Management

Step 6 - Asset Register Conceptual Data Model

Getting Started Conceptual Data Model for Asset Management
Step 2 - Define Sample Data
A. Asset Hierarchy :-
1. Category, eg Domestic
2. Supertype, eg Cutlery
3. Type, eg Spoon

B. Lifecycle Phases :-
These can be common to all types of Assets and typically include :-
1. Acquire
2. Use
3. Maintain
4. Dispose

C. Status :-
1. Needs Maintenance
2. OK
3. Ready for Disposal
Step 10 - Start with our Canonical Data Model


Canonical Data Model


Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
August 21st. 2017


© Database Answers Ltd. 2017