"Data Model Patterns" by David C Hay is probably what you want.
It doesn't cover class scheduling, but you can always look at the OpenACS source code for that.
Also, "Object Models: Stategies, Patterns and Applications" has some interesting case studies. It's no directly applicable to relational databases - more about the middle tier (OO layer), but still worth a look.
