Add association, related functionality, and associated tests for Course and Semester.