Yes, it can be used to show a timetable. You only need to transform your day value to a certain date.
The easiest way would be to pick a year which starts on the same day of the week. That's the case of 2012 (for weeks starting on Sunday). So you can store Sunday as 2012-01-01, Monday as 2012-01-02 etc.
You can also store days of week as integers and transform them to dates using your SELECT command.
In the Calendar, set HeaderDateFormat="dddd" to show just the name of the day in the header. Use BeforeEventRender to override the default event HTML if needed.