I have a situation where customers can rent bikes. They are charged a one off annual fee. They are also charged when they rent a bike based on how long they had it (different rates for different lenght of times.). I'm thinking of having a seperate table for the annual fee and then a table to for each rental. The problem is i'm not sure how to link the fee table. I've attached a pic of what i've done so far. Any help would be greatly appreciated.
Charging One Off Annual Fee
- Thread starter Lancer1
- Start date
- Local time
- Today, 01:11
- Joined
- Sep 12, 2006
- Messages
- 16,001
offhand i wouldnt have a different table for different payment types, but I would have a field distinguishing the type of fee in the fee paid table. That way you only have ot link one table, but you can still separate the fee types
Well I'd suggest you start by throwing out your Fee table and delete "Annual Fee" in Customers: after all, if customer Jim has paid an annual fee of $50 in 2008, and in 2009 needs to pay $55, where would u store that second fee?
Secondly you could create a new table FeeType, with 2 fields: FeeTypeID and FeeTypeName. FeeTypeID values could be 1,2,3 and so on, while FeeTypeName values could be "Annual", "Monthly", "Quarterly", "TwoQuarterly", etc.
FeeTypeId will have to be added to Rentals of course, as a FK. So from now on every entry in Rentals will have a Feetype.
HTH
Secondly you could create a new table FeeType, with 2 fields: FeeTypeID and FeeTypeName. FeeTypeID values could be 1,2,3 and so on, while FeeTypeName values could be "Annual", "Monthly", "Quarterly", "TwoQuarterly", etc.
FeeTypeId will have to be added to Rentals of course, as a FK. So from now on every entry in Rentals will have a Feetype.
HTH
