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


> 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



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