Database Answers Medical Results
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Collectables   
An Access Database is available on demand.
The Specifications for the Data Model were provided in a question to our Web Site.

We might design a Data Mart, which is 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.


Step 1 : First we define the 'Things of Interest' Our first draft is Collectables, Features, Owners and the History of each Collectable.

Step 2:How are they related ?
When we think about how these various things are related,
we can define the Business Rules and
how they might look in a Conceptual Data Model.

Conceptual Data Model


Step 3: Here we add the details required to create the Logical (ERD) Data Model
When we think about how these various things are related, we can define the Business Rules.
This is how they might look in a 3NF Normalised Data Model.

Dezign ERD Data Model for Collectables

Step 4: Add Data Types to generate the Physical Data Model

Physical Data Model


Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
September 25th. 2015


© DataBase Answers Ltd. 2013
About Us Contact Us