Data Model for Asset Management


Printer-friendly version

Careers

Data Model for Asset Management

An Access Database is available.

We have also designed a Data Warehouse and a Data Mart which are 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
Step 5 - Asset Register Physical Data Model
Step 6 - Asset Register Conceptual Data Model
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

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
August 22nd. 2017

About Us