I am currently teaching BSYS 2060 – Business Applications III at BCIT in the School of Business. The course covers data modeling and MS Access 2007. In their team project, students build a fully functioning database to help the Vancouver Board of Parks and Recreation manage their skating lessons across their eight ice rinks.
It’s a pretty informal partnership… they haven’t committed to using the database but hopefully they will find one of the top team submissions meets their needs and they can use or at least it will give them some ideas.
I’m hoping this way students can get some “real life” experience with databases, get beyond the “mouse clicks” of MS Access 2007 and really dig into data modeling… also hoping that the community will benefit from the student’s creativity.