Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cris Abella
  Where is Cris Abella?
 Davao City
 Philippines
 Cris Abella
 To: BZ Dusk
  
 
 
 BZ Dusk
 Tags
Subject: RE: Table structure in Video Rental Application
Thread ID: 22614 Message ID: 22705 # Views: 0 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Thursday, April 24, 2003 6:17:10 AM         
   


> > hi there,
> >
> > Is there anyone can give a sample of table structure of Video rental application.
> >
> > thanks in advance
> >
>
> Hi!
>
> I haven't done any video rental application, but if if ever I will, this will be my approach:
>
> First off, you need a video or movie category file maintenance. This category file maintenance will classify the movies whether they are horror, comedy, suspense/thriller, drama, action, x rated :).
>
> Structure would be: catid,description
>
> Then you will need to have the main movie file maintenance - refid,description,catid (from the category dbf), number of days when this video must be returned, rental amount,etc.
>
> Customer file maintenance - info of your customers.
>
> I think you will need transaction modules for the inventory of the videos - videos received from the copy center, videos returned to the copy center (if rejected or damaged), etc.
>
> Then the rental transaction module-refid,date rented,customer,date returned, rental amount (should save this coz rental amount may change),penalty, etc.
>
> Just an idea, i hope this will help.
>
> BZ
>
How could we determine whether if a particular customer had unreturn videos, if he rents again another video?

COMPLETE THREAD

Table structure in Video Rental Application Posted by Crisologo Abella @ 4/23/2003 7:23:19 AM
RE: Table structure in Video Rental Application Posted by BZ Dusk @ 4/23/2003 7:57:38 PM
RE: Table structure in Video Rental Application Posted by Crisologo Abella @ 4/24/2003 6:17:10 AM
RE: Table structure in Video Rental Application Posted by BZ Dusk @ 4/24/2003 7:23:46 PM
RE: Table structure in Video Rental Application Posted by Crisologo Abella @ 4/26/2003 6:21:08 AM