[AccessD] Video Rental DB

[David McAfee]

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
>