ACCESS DVD Database

Hi Jack,

Back in 2002, when I was teaching a beginning Access course, I once spent
some time with Michael Hernandez at a local Starbucks shop talking about a
design for a Video database. In particular, I had a "unique" design that a
student submitted to me, that I wanted an expert opinion on. You may
recognize the name. Michael is a database design expert, and author of
Database Design for Mere Mortals.

After discussing the student's design, Michael proposed a design that is
very similar to that which John Vinson just volunteered. I thought you might
want to have a look:

http://home.comcast.net/~tutorme2/sa...rVideosMJH.snp

You will need to have the Microsoft Access Snapshot Viewer installed, in
order to open this .SNP file:

Microsoft Snapshot Viewer is available in download center
http://support.microsoft.com/Default.aspx?id=175274


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"John W. Vinson" wrote:

I've been watching this thread with interest, Albert - let me ask you what you
think of an idea I've had.

Not only might some (small?) fraction of movies have multiple directors; but
perhaps you might want to keep track of other people, neither actors nor
directors. Producers, costumers, set designers, key grips and best boys...
well, this could get silly... but might another modification involve

tblPeople
PersonID
LastName
FirstName
other bio data

tblPeopleInvolved
DVD_ID
PersonID
RoleID

tblRoles
RoleID
Role e.g. Leading Actor, Director, Associate Producer, ...

Just throwing out the idea for consideration!

John W. Vinson [MVP]