To set the stage, I've been trying to model the web content of the Academy's website. This has been an on-and-off little puzzle since I redesigned their website initially.

Because there was such a varied amount of content, with the pages containing varied sections, all of which vary, I had trouble abstracting a solution out in my mind.

Finally, however I believe I have come up with something. I believe the model below can help get there. Now I just need to figure out the SQL to get the data I want.