The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ DVD's...
Purpose...
This data model was designed to handle DVD, CD and game cartridge management.  (Note, there only tables included in this database the balance is up to you!)  Special thanks to Home Theatre Info for the DVD data in the tables!
Business Rules...

There may be multiple Directors for each DVD

There can be multiple Actors to one DVD

Studios can produce more than one DVD

Directors can be on than one DVD

Actors can be on more than one DVD

Main Entities...

DVD's  (Games, videos, etc...)

Actors

Directors

Each DVD will be produced by one Studio

Download Sample (Access 2003 and Unzipping program needed)
aaaaaaaaaaaaiii