 |
An Access Database is available on demand.
If you have any comments or suggestions
we would be glad to hear them.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
The specifications have been derived from a review of the Wikipedia Entries for
Procurement
and
E-procurement.
There is also a Dimensional Model (4 below), which is very useful for providing data for Analysis, Enquiries, Reports and Business Intelligence.
Here we show our unified end-to-end Cloud-based Platform
|
1) Business Rules
These Businuess Rules define the guidelines for the Business Model.
- A Customer can generate zero, one or many Requests for Products or Services.
- Many Suppliers can respond to each Request.
- Other organisations can respond to a Request, such delivery companies.
We refer to these as 'Parties' and each Party can play one Role in the
Procurement process.
- Other organisations can respond to a Request, such delivery companies.
- We can define a number of Events in the Procurement Process, such as Delivery or Payments.
|
2) Business Data Model
This is intended for Business Users
|
3) Logical Data Warehouse Model
This Model is the next step to the generation of the
physical Database and is intended for Data Analysts and DBAs
|
4) Dimensional Model (or Data Mart)
This Model provides data for Performance Reports
and is intended for Analysts.
The data is the same as that in the Logical Model but
provides sub-totals to provide answers to questions like these :-
1.'What was the value of Contracts awarded in April ?'
2.'Which Contractor won the most Contracts last month and
what was the total value of the Contracts ?'
|
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
May 5th. 2018
|
© Database Answers Ltd. 2018
|
Printer-friendly version