I have a database (or am designing a database) for SQL compact 3.5, and as I haven't done this before, I know that the planning is everything.
In my attachment, you will see my tables and the primary key and foreign key relationships in the first page. And in the second page you will see an example of the tables in use. I didn't upload or print the row and column headings as I need to understand the SQL table code.
How can I calculate the "Current Balances" in the "Expense Accounts" and "Payment Types" tables? How should I setup a table to show the deposits/transactions for an account/payment type by month? I am not sure if I should have a separate month table to log that data or not. In the program, I will generate a code that automatically creates a new month feild/column that will store that months date.
This is my first database and I am trying to understand how they work.