Number of Tables & Relationships

access12

New member
Local time
Today, 10:58
Joined
Jan 10, 2010
Messages
4
I want to build a Financial Database. We are provided a certain amount of budget under different heads each year. Every month we spend some money from some or all heads. Then we provide a detail of expenditure during the month under each head and the balance thereof.
My request is how many tables I need in my database. My opinion is 5 tables each for Years, Months, Heads of Expenditure,Budget Allotted, and Expenditure. Also what kind of relationships I shall make between them.
Hoping for your response.
 
From what you've described I only see 2 tables: BudgetAllocation and Expenditures.

If you can provide sample data I get be more specific, but right now you only have 2 tables.
 

Users who are viewing this thread

Back
Top Bottom