Database Answers Inspection Services (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Inspection Services   
We demonstrate how to develop a 3NF Data Model and Data Marts from scratch, using our Best Practice Event-driven Approach.
An Access Database is available.
The Specifications for the Data Model were obtained from a review of the Control Union Web Site.

We might also design a Data Mart, following our 'Best Pratice' Event-driven approach.
The Data Mart would be very useful for providng 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.

This Model show only Entity names which makes it easy to read.

When we think about Inspection Services, we think about Customers, the Products and Services that we offer, our Global Offices and the Consulting Assignments that we carry out for our Customers, our Staff and the Community Projects that we support.

So we end up with this draft list of 'Things of Interest' that provides our starting-point for designing the Data Model ...

Data Model for Inspection Services
Then we think about how these various things are related, and how they might look on a 3NF Normalised Data Model.
Here is a summary of part of our thought process :-
1. Products
We have not included Products because it is not clear to us at this stage what they are.
We could include them with 'Services' but that would make our Model look untidy so we have left them out ;-0)
2. Staff on Assignments
We like the idea of keeping track of the Assignment of our Staff because Staff are a very important part of Custom Union's operation.

ERD Data Model for Inspection Services

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
December 6th. 2013

© DataBase Answers Ltd. 2013

About Us Contact Us