473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Database Design DVD Movie Collection Database

Hi Everybody,

Apologies if in wrong section

I am designing a DVD Movie Collection Database for my own personal use and requiring a little help.

Brief description: The key tables are tblMovies, tblLoans with the following key fields

MovieID (Autonumber)
MovieTitle
Status: Available or Not Available

LoanID
MovieID
MemberID
LoanStatus: Status Loaned or Returned

My query is there a way to store multiple Movies Title with the same Movie ID.

Scenario: DVD contains the movies Saving Private Ryan, Spiderman, Star Wars and a friend loans the DVD, I would like it to be in effect all three movies status “Not Available”.

I already know I could put all 3 movies in the one field MovieTitle, which will fix this, but this isn’t a good solution as this won't sort my movies into a true alphabetical order and movie count would not be accurate

If somebody has any tips or advice, or if my thinking is wrong please reply
Oct 22 '07 #1
2 5520
missinglinq
3,532 Expert 2GB
You're correct; placing the three movie titles into one field would be a major mistake! I think what you need to do is to add one more field to the mix, say DVD_ID. That way, when the DVD is on loan, you can show that any movie associated with the particular DVD is unavailable. If you have multiple copies of a given DVD, each would have to have its own DVD_ID.

Welcome to TheScripts!

Linq ;0)>
Oct 22 '07 #2
What I would suggest is making a third table, call it tblDisc or something. This table would have the following fields:

DiscID
MovieID
LoanStatus

This way you can keep track of all the movies on each disc and still have unique MovieIDs and titles. Depending on the database you're using, you can make MovieID a foriegn key. This way if LoanStatus of the disc changes you will have a way to update the LoanStatus of any movie on that disc.

You could also alter your tblMovies table and add a DiscID field.

The point is all you really need is a way to track a unique ID for the disc.
Jan 30 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: hplloyd | last post by:
I am fairly new to VB.NET programming but have built many database applications in Access SQL Server etc. I need to find a good book or other reference material that will help me take my OO...
2
by: Josh McFarlane | last post by:
If this is not the right place to post this, I apologize. I've taken over work for a few utility programs for a collection of database / raw files. All the programs but one read from the files,...
2
by: SammyBar | last post by:
Hi, I'm trying to bind a custom collection class to a data grid, following the guidelines from the article http://msdn.microsoft.com/msdnmag/issues/05/08/CollectionsandDataBinding/default.aspx....
6
by: Bob | last post by:
It's been quite a while since I've built an Access database, but I suppose it's like riding a bicycle and it will all come back to me. But I'm not sure Access is the proper tool for what I want to...
0
by: Gilbert | last post by:
Hi Can anyone point me at a tutorial that explains how to "design/set-up" an XML database. Most of the tutorials I've found are just the basic how to setup a collection, and query it. Given that...
1
by: BenCoo | last post by:
Hello, I have a ProgramItem-class as follow: mItemID as Integer
2
by: =?Utf-8?B?SG9sbHk=?= | last post by:
Please help...I'm trying to make a movie of different clips. I can add a set of clips from one collection to the storyboard and it plays fine. Then I will add another set of clips from another...
7
by: nma | last post by:
Hi I'm trying to display data in a table list format but error message like this appear. What is wrong with the code? "Parse error: syntax error, unexpected '<' in C:\htdocs\...\MB2movieinfo.php...
5
by: Kaosman | last post by:
I have been trying to figure out this problem for a while. All I want to do is have a combo box populate a list box and the list box change to the record based on the users choice. The combo...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.