I've done some poking around, but haven't been able to get my head around this. I'm working on modeling expenditures for a non-profit, and I'm not sure how to proceed because there seems to be more than one many-to-many relationship involved. A given expenditure will have 1 or more funding sources attached to it, as well as 0,1, or many clients served. Obviously, each of those funding sources or clients will also potentially be attached to multiple expenditures.
I can model either of these easily with a junction table, but I'm not sure how to handle both. Can I use a single junction table for this purpose? If not, I do need to relate the two (funds and clients); it seems like I could do that using the shared Expenditure key value even with two separate junction tables, but I've never done it before.
What should my table structure look like here?
I can model either of these easily with a junction table, but I'm not sure how to handle both. Can I use a single junction table for this purpose? If not, I do need to relate the two (funds and clients); it seems like I could do that using the shared Expenditure key value even with two separate junction tables, but I've never done it before.
What should my table structure look like here?