Data Model for Asset Management Self-Service
Back to the Home Page


Step 1a - Define Conceptual Data Model


Step 1b Appsheet Tables


Step 1c Test Data
1 Customer - Bobby Caldwell
1 Platform Code - Asset Mgt

Asset Items ID| DATE | QTY| ITEM NAME | 1 | April 1/2018 | 1 | Sofa | 2 | April 1/2018 | 4 | Dining Chairs | 3 | April 1/2018 | 1 | Carpet | 4 | April 1/2018 | 1 | Cutlery for 4 | 5 | April 1/2018 | 1 | Pair of Black Shoes | 6 | April 1/2018 | 1 | Blue Sweater |




Step 1c - Define Logical Data Model


Step 1d - Define POC Logical Data Model Aug28th.

Step 2 - Define POC Logical 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 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 Self-Service
Step 5 - Asset Register Physical Data Model

Physical Data Model for Asset Management Self-Service

Step 6 - Asset Register Conceptual Data Model

Getting Started Conceptual Data Model for Asset Management Self-Service
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
October 6th. 2017


© Database Answers Ltd. 2017