We live in a house with 5 people and we share 2 cars. It's been working out ok but we thought it would be more efficient (and cool) to write a little application where we "checkout" cars a la zipcar. We're not looking to build anything fancy - just a basic registration system that (a) lets us know when the cars are available and (b) lets us reserve a car. I'm thinking of something like this:
(The hours table needs to be there because our garage is open only within certain hours during the day). Am I thinking of the problem correctly? Any suggestions would be greatly appreciated before I spend the next few days (or weeks?) on this.