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

Microsoft Access Data Model Example

Video Rentals Database Scenario

The following data model is designed to hold information relating to a video rentals store. 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:

  • Members
  • Rentals
  • Video Copies
  • Video Titles
  • Video Category
  • Video Certification

The Entities are related as follows:

  • A Member can Rent One or Many Video Copies
  • A Video Title may have One or Many Video Copies
  • A Video Copy may be Rented by zero, one or many Members
  • A Video Title can have only one Certification associated with it

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

  1. Do we currently have any overdue video rentals?
  2. Do we have any videos in a certain certification available to rent?

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 Video Rentals Data Model

Please download the data model relating to Relationships for Video Rentals which is contained in the zipped up Microsoft Word document.