Simple resources database
I have a small database with several hundred resources of varying types (medical, education and research, for example).  Each resource will need to be identified by its region.  Some of the resources serve multiple regions.  I need to be able to define each resource by its type, and it's region.  

Since one region will have many resources, and one resource can serve many counties I figure I should have a junction table between them, right? 

My question is, should I have a junction / linking table for each resource type?  Should I have a table of education_resources, regions and link them with a junction table education_regions? And do the same thing for the rest of the categories?  





Simple resources database
===

I have a small database with several hundred resources of varying types (medical, education and research, for example).  Each resource will need to be identified by its region.  Some of the resources serve multiple regions.  I need to be able to define each resource by its type, and it's region.  

Since one region will have many resources, and one resource can serve many counties I figure I should have a junction table between them, right? 

My question is, should I have a junction / linking table for each resource type?  Should I have a table of education_resources, regions and link them with a junction table education_regions? And do the same thing for the rest of the categories?  




