[AccessD] Video Rental DB

[Darryl Collins]

Yeah, that is about right.  It is super useful for home and even corporate use, but your needs (as I suspected) are going to be a bit different.

Oh well...



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

Just a quick glance, that appears to be more of a software to collect a list of movies and / or music.

A little back story. :)

Back in February my wife (and I) bought a little retail store. In the back of the store was a video rental section.

We were going to shut it down, after all who rents movies at a brick and mortar store these days? :)

Well, we come to find out, a lot of people. We add at least 1 new customer per day as they find out about it.

The P.O.S. (if you can call it that) for the rental side of the store is an old DOS based application running on a Windows ME or 2000 system. I think POS doesn't stand for Point of Sales, it's more like Piece of Sh*t :)

I could copy the flat dbase table structure thatthe software uses, but I'd like to design something a little better.
I want to do it in Access first as a rapid development tool, just to show the employees my thought on how the software should work.

In time, I'd like to connect to the web and/or make it a mobile app or web based software.

On Thu, Jun 30, 2016 at 2:22 PM, Darryl Collins < darryl at whittleconsulting.com.au> wrote:

> 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.
>
> Cheers
> Darryl.
>
> -----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:
> https://drive.google.com/open?id=0B3zNbKE_HKVBMDJ6XzYtbWJ6UHM
>
> 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,
> David
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com