Database Answers Mass General Hospital (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Data Models Search Site Map
Data Model for Electronic Medical Records   
An Access Database is available on demand.

If you have any comments or suggestions we would be glad to hear them.
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

The specifications have been derived from a review of the Wikipedia Entry for Electronic Medical Records.
On January 7th, 2017, I updated my Data Model in line with a coule of excedllent suggestions from Andrew Davies.

Andrew also made me aware of the existence of the open EHR and here's the Wikepedia Entry.
After I updated my Data Model second version is in line with my Event-oriented canonical Data Model.

There is also a Dimensional Model, which is very useful for providing data for Analysis, Enquiries, Reports and Business Intelligence.

Here is the Physical Data Model for the SQL Script to generate the MySQL Database.

Data Model - Version 2
Data Model for Electronic Medical Records
Data Model - Version 1 - April, 2013

Data Model for Electronic Medical Records

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
April 3rd. 2013

© DataBase Answers Ltd. 2017
About Us Contact Us