> 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