Seem the obvious relationships here, but others may me needed or useful to you.
Assets----<Expenses could be used to link expense records to specific expenses so that you can track repair and maintenance costs for each asset.
A staff person could be shared by two or more departments (One secretary might serve more than one department), in which case you'd need a join table for matching staff to departments.
Since staff and members data will largely consist of contact info and your staff may also be members, you might want to put all staff and member records in the same table, using an added field to identify who is on staff and another that identifies someone as a "member".
Other detail tables may be useful. For example, these days, people have multiple email addresses, social networking links and phone numbers. You might manage all these with an added table linked to Members.
Thanks for the quick reply. I like you suggestion to merge STAFF and MEMBERS.
Let`s call the new merged table CONTACTS
What do you think of this new layout? Any suggestion?
CONTACTS --< CONTRIBUTIONS
CONTACTS --< EXPENSES
ASSETS --< EXPENSES
DEPARTMENTS -- <DEPARTMENT_STAFFING >-- CONTACTS
It works, though some developers would merge contributions and expenses into a single table with contributions stored in one field and expenses in another. This allows you to set up a ledger type report where you can see contributions and expenses in different columns of the same layout with a running balance computed much like you'd see in a traditional check register where you might log deposits (contributions), withdrawels (Expenses) and then compute the current balance.
Much thanks Phil,
Your advice is exactly what I was looking for. I will indeed merge EXPENSES and CONTRIBUTIONS into FINANCE. This will simplify the diagram and give me more control over data. If you don't mind, I will consult you from time to time to get your thought on how somethings are best done.
I haven't developed a solution in a while and I lost good habits in the process. I am rethinking my old ways and I wanna make sure what I do is in sync with today's accepted standards.