Hi all,


This is my first project. I hve chosen 'car rental ageny' as my project.
I hve decided to hve the following tables in my project.

Customer Table(This table holds all the customer details)
 cuid
culname
cufname
cuhphone
cuwphone
cucphone
cuadd1
cuadd2
cucity
custate
cuzip
no-of-times-rented
cutype
culic
cussn

Vehicle Table (This table holds the all the details abt the vehicle at car rental agency)
vehplate
vehmake
vehmodel
vehmacyear
vehgps
vehsize

Company Master Table (This table has all the information abt its branches)
comloccode
comadd1
comadd2
comcity
comstate
comzip
comphone
comfax

Rate Plan Table (This table has info about the rate. if it is a minivan and its a weekend , then the rate is so and so like .)
ratecode
rate
vehsize

Transaction Table (This table holds the transaction for each rental going to take place)
tranid
vehid
cusid
rate
pickupdate
dropoffdate


Now i need the suggestion ..am i right in all these or do i hve to add something here. pls help me..

thx in advance..
sangsram

Where does the Company Master table find its place in your database. I cannot find any relation with any of the other tables.

Regards
Ganesh

HI,

Sounds good. I am not if its a Produstion project or an Acdemic. Lot of other things depends. Anyways here are the points :-

1) In Vehicle Master there should be a VehicleID (May be PK).
2) Vehicle Size master is also required.
3) In Transaction table there should be RateCode instead of Rate.
4) You need a Vihice Modal and Vehicle make Master also.

Rest I suggest to get started with this model. Always keep reports reports reports in mind and you will get some more tables comming in picture.

Gud luck

B. Anant

thx guys. i hve a vehid too. i think that was a typo error.
The company master table gives details about other branches. suppose a customer asks wheater there is a branch in a particular location then the employee may use this table to look up..am right or not?

 other changes i will do. while talking abt the reports how it shld be ? ..like

reports for a particular date
reports for a particular customer

thx
sangsram