I am having trouble figuring out what tables to create and how to setup the relationships properly to design a sturdy normalized database for personal finance. I am wanting to create a database that will be able to track income and expenses and compare it to budgeted amounts in each category and subcategory. I want to be able to create a budget that can be tracked not just by monthly, but mainly based on pay periods. Being able to budget the individual paychecks and what gets paid out of each.
The 2nd part is to be able to track all expenses and transfers both into and out of the acounts. There will be multiple accounts being tracked this way.
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.