Graphing Class Demographics
I have a database with four tables that are relevant to this problem: Contacts, sign-ups, and programs, and program types. Contacts are related to sign-ups by first are last name, which are then related to programs by the program name, just like the example in the tutorial for many-to-many relationships. Programs are related to the program type table by a "program type" field, and the program type relates different instances of programs from different years (so if there was a program on diabetes in 2010, 2011, and 2012, they would all relate to each other). What I'd like to do is create a graph of the demographics for each type of program - i.e., a histogram of how many people are in each age and gender category for a given type of program.