databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access Data Model Example

DVD Collection Scenario

The following data model is designed to hold information relating to a personal DVD 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 Entities required should include:

  • Actors
  • Film Titles
  • Film Genres
  • Actor Roles
  • Producers
  • Film Certificates

The Entities are related as follows:

  • An Actor can be involved in many Films, in different Roles
  • A Film can have many Actors
  • A Film Genre can have many different Films
  • A Film Certificate can have many Films
  • A Film can have many Producers
  • A Producer can produce many Films

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

  1. Who stared in a particular film, in what role?
  2. Do you have any PG certified films in your collection?
  3. Who were the Producers of a particular film?

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 DVD Collection

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