designing tables for a pls


New member
Dec 5, 2004
Programming Experience
hi all,

i am new here. and also new to sql server and i thought of doing a simple project for a car rental agency. first i thought of the front end and back end as sql server. i designed the following tables for this project.

customer table
vehicle table
rate table - this hold the holiday and weekend rates
transaction table
location table - this holds the info about other arear where they are located

am i doing all these right. or do i need to add anything etc here.

help of now am not doing this as a web based one. just a simple one.

thx in adv
Top Bottom