Database Answers Asset Lifecycle
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Asset Management   

An Access Database is available.

We might also design a Data Mart which is very useful for providing data for Reports and Business Intelligence.

We would be glad to have your comments.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

Click here to see the Requirements that have been derived from a review of the Wikipedia entry for Asset Management.
Here is a summary of What Wikipedia says :-
"Asset management, broadly defined, refers to any system that monitors and maintains things of value to an entity or group.
It may apply to both tangible assets [that you can see and touch] (such as buildings) and to intangible assets such as human capital, intellectual property, goodwill and/or financial assets). Asset management is the process of maintaining assets."
For our purposes, we define Asset management as "Storing physical items, such as furniture, for customers for a fee and recording details of what it in store and for long and producing an appropriate invoice for payment by the customer".
Click here for the Proof-of-Concept and here for the End-2-End Data Models and here for the Tutorial.


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 22nd. 2017


© DataBase Answers Ltd. 2017
About Us Contact Us