Normalisation

[jimeee]

Normalistion
HELP ME!!!!

Hi, I'm writing a database for a friend of mine. He has a collection of DVD's which he loans out.

I need a table which stores the DVD, the programs on it, the scenes on the program, the length of the scenes and a description of each scene.

Now here's the complicated bit

There may be 1 or more programs on each DVD
There may be 0,1 or more scenes in each program
AND there may be a 0, 1 or more descriptions for each scene

As you can appreciated there are many normalistion problems, especially as there are the users and the users loans of the DVD's to consider.

Any help is very, very VERY much appreciated and I thank in advance anyone who can help me. (Grovel)

Jimeee

 

[antomack]

Check out the Microsoft template available below for DVD collection, it may be of some help.

http://search.officeupdate.microsoft.com/TemplateGallery/result.asp?qu=access

 

[jimeee]

Thanks a lot!