[AccessD] Video Rental DB

Darryl Collins darryl at whittleconsulting.com.au
Thu Jun 30 16:22:49 CDT 2016

I suspect this solution is not quite right for you and what you want to do, but maybe it will do the job and save you a whole stack of time and effort.

<< http://www.collectorz.com/>>

Worth a look.


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Friday, 1 July 2016 6:19 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [AccessD] Video Rental DB

I'm creating a Video Rental database, and have a couple of roadblocks that I am trying to get through.

A picture of  video / disc schema is available from my Google drive here:

I have three questions:
1. tblStatus currently has status choices of "In", "out", "Sold", "Damaged"
 I was thinking that I would put a StatusID FK field in tblDiscs to reflect if the disc is currently in, out or otherwise. Then I started thinking that I should have a junction table in between to keep a history.  Then I started thinking that it really should be tied to tblInvoiceLine, which shows when it was rented out. Any ideas on which way to proceed?

2. tblRentalSales was designed to track when an older, multiple copy has been sold off. Really, I should put a flag in tblInvLine to indicate if that particular line item was "sold" rather than rented (both can happen in one transaction). Also, this could affect the previous question (Status of disc is now sold)

3. Games (Xbox, Playstation....): I am unsure whether or not to make it a flag in tblTitles, or set it in tblGenres or even tblFormat. tblFormat (DVD, BlueRay, VHS...) could have a choice of Game, or even more granualar such as XBOX.

I was thinking of using tblGenres (Horror, Comedy, Action...) for games as I do for Movies, but I guess I could use them for game platform such as  Playstation (what about Xbox 360, Xbox 1, PlayStation 3, 4...).

Any way, I would really appreciate any suggestions for any or all of the three questions.

Thank you,
AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list