Data Model for Construction Companies


Printer-friendly version

Home

Careers

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

About Us