 |
I created this Model after I attended a very interesting meeting organised by
Sedex
and the UN Global Compact (UNGC)
about Supply Chain Transparency.
An Access Database is available.
We might design a Data Mart (Dimensional Model) 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.
|
|
The Proof-of-Concept Screenshot
The data shows that Bobby Caldwell paid for a Retail shipment.
|
Logical Data Model (ERD)
|
Proof-of-Concept Tables
|
Our approach has 6 Stages in the Supply Chain.
Customer
Retail
Distribution
Factory
Supplier
Raw Material
r
|
Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
July 13th. 2017
|
© Database Answers Ltd. 2017
|
Printer-friendly version