An Access Database is available.
Here are the Specifications and the
Data Model for our Proof-of-Concept.
We would be glad to have
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
We might also design a Dimensional Model.
For the Proof-of-Concept, Apex will be used to create and modify
data in the Documents, Locations, ‘Products in Shipments’
and Shipments tables.
Spreadsheets will create data in the Customers and Products tables.
1) Conceptual Data Model
2) Logical Data Model - Entity names only
The Physical Database Model
This shows the final step in the process of generating a Database from a Conceptual Model.
3) Physical Data Model
Database Answers Ltd.
July 28th. 2016