Ex1 ... find students given partial name
Ex2 ... count courses offered in a given term
Ex3 ... list of programs that student was enroled in
Ex4 ... course enrolments for all courses in a given term
Ex5 ... update anomalies
mymy.dump ... database used in Ex1 - Ex4