Database Answers Ealing tOwn Hall, London, England (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 Local Government  and the Internet of Things 
An Access Database is available on demand. This Model is based on our Canonical Data Model.

There might also be a design for a Data Mart which is an excellent start for Enquiries and producing Reports.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

This Model is Event-Centric and provides a good starting-point, and a Many-to-Many Model has also been created in ERwin.

Two aspects of a Thing that are very important in the Internet of Things are its Location and Status and these are monitored at all times.


Logical Data Model


Physical Data Model



Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 21st. 2018


© Database Answers Ltd. 2018
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map