Database Answers WW2 Aircraft B25
Printer Print Version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Aircraft from WW2   
An Access Database is available.

We might also design a Data Mart which is very useful for providing 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.

Conceptual Data Model

Conceptual Data Model

The Requirements

The Requirements have been defined as follows - "Hi Barry I'd value your opinion on a database model I am considering creating in MS Access. It will be a database of a particular aircraft type from WW2. I have all the data on paper and want to include Each aircrafts registration number It's place of manufacture, whether it was Mark I II III etc. Engine type The squadron/training units it was assigned to in it's history. I looked at the Database in the subject and wondered if you consider this to be a good starting point, or have a better example? Kind Regards Neil"

Steps in the Approach

Step 1. Identify the 'Things of Interest' within Scope of the Data Model.
Step 2. Determine how they are related
Step 3. Establish what else we know about them
Step 4. Look for occurrences of Design Patterns.

Barry Williams
Principal Consultant
February 8th. 2016
Database Answers Ltd.
London, England

© DataBase Answers Ltd. 2016

About Us Contact Us