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
If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.
Conceptual Data Model
The Requirements have been defined as follows -
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.
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?
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.
February 8th. 2016
Database Answers Ltd.
© DataBase Answers Ltd. 2016