- database solutions and downloads for microsoft access

Microsoft Access Data Model Example

Book Collection Scenario

The following data model is designed to hold information relating to a personal book collection. For this scenario we need to define the following facts:

These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.

The draft facts have been defined as:

The Entities required should include:

  • Authors
  • Books
  • Book Formats
  • Book Categories
  • Publishers

The Entities are related as follows:

  • An Author can write many Books
  • A Book can have many Authors
  • A Book Category can have many Books
  • A Book can have many Categories associated with it
  • A Book Format can have many Books
  • A Publisher can publish many Books

When asking questions of the database we may need to know:

  1. Do you have any Books by Jilly Cooper
  2. Do you have any Books in the Sporting Category
  3. Do you have the Hardback edition of Riders

The following data model allows these questions to be answered and allows the information contained above to be stored logically and in a structured manner.

To view the model please go to: Relationships for Personal Book Collection

Please download the data model relating to Relationships for a Personal Book Collection which is contained in the zipped up Microsoft Word document.