Database Answers
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Construction Companies   
We would be glad to have your comments.


Conceptual Data Model
This Model uses the 'Projects Events' Entity as central point for all other Entities.


Summary
Here we define the Steps in using the Model on the left to define a Data Dictionary.
Step 1. Produce a Business Data Model in discussion with the business and IT.
Step 2. Create a Subject Area Model for each Business Entiytity, eg 'Suppliers'; 
Step 3. For the moment, adopt JD Edwards as the 'Master' and each Subject Area Model, 
           drill-down to create a  list of JD Edwards Data Entities in a Data Dictionary.
For example,'Suppliers' in the model on the left might correspond to 'Supplier Master' 
in the JD Edwards 'Accounts Payable' Data Model shown below.

Here are draft Subject Area Models to provide a starting-point for discussion ...
Clients  ,Documents  ,Events  ,Locations  ,Payments  ,Projects  ,Staff  ,Suppliers
Simple example of a Data Dictionary mapping to JD Edwards
TERM SOURCE JDE EQUIVALENT MEANING
Customer Internal   Organisation that buys goods or services from Supplier
Supplier Internal Supplier Master A Person or Organisation that supplies goods, services or Staff to a Project


Here is the JD Edwards 'Accounts Payable' Data Model from Silwood Technology (the 'Safyr' people)


Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
November 8th. 2016


© Database Answers Ltd. 2016
About Us Contact Us