Video rental

jumper

New member
Joined
Apr 28, 2005
Messages
4
Programming Experience
Beginner
High there,

I'm in search of a database for a video rental store.
I've have something like this(in dutch)
http:/users.pandora.be/Jumper/relaties.JPG

But I don't think it is correct.
I need the db for a project in Visual Basic. So I can't start if I don't have such a DB.
Can somebody help me with this?
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
Well you probably want to keep it simple, really you only need 3 tables:

Clients
Videos
CheckedOut

checked out would link to the other 2 using there ID
 

jumper

New member
Joined
Apr 28, 2005
Messages
4
Programming Experience
Beginner
yes, but they can rent 3 movies.
What do I have to do when they return 1 movie on time, and the other 2 to late?
And something else:
I have of each video 5 pieces.
 

TPM

Well-known member
Joined
Dec 7, 2004
Messages
623
Location
CA
Programming Experience
3-5
You add 3 records to the checkedout table.
Give them a fine.... :)
Well you could have an instock column in the videos and update it.
 
Top Bottom