MySQL Forums
Forum List  »  Newbie

Help with database design
Posted by: Marcus Reed
Date: October 30, 2009 08:04PM

I want to build a database to track vehicle expenses and I'm trying to figure out the best way to build something like this. I want the users to be able to insert records for things like maintenance, gas, tolls, etc. Any other ideas someone has feel free to elaborate on this. When I am thinking about how this will work, my idea is that I would have one master expense table with primary key of ExpenseID, and sub tables like maintenance, gas, tolls, whatever and those would be linked to the ExpenseID right? Please help, I'm not the best with conceptual thinking. ;-)

Options: ReplyQuote

Written By
Help with database design
October 30, 2009 08:04PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.