normalization resource
good, simple and common sense...
one thing that took me a while to realize is that students in ciss243, despite having ciss143, need a lot of database review. this is not meant to criticize them. for some it has been a while since they've had the class. additionally, if the students have had no opportunity to practice their db skills, then, of course, they will rusty. also, different instructors focus upon different things - perhaps their ciss143 instructors did not cover the stuff re:databases i feel is critical. because of that, i am devoting a fair amount of time to revieweing it. it would be a disservice to try and rush into the .net until we have a time to review the basic db concepts.
good article on normalization
something to read if you get bored over spring break. although it is on a site about php, the concepts are the same - and what the author says about db design can be applied on any platform...
i think cutting down on the client side stuff was a good move this term. that reduced the duplication between this class and ciss232, and allowed us to really focus on the important stuff for vb.net. we are really at a good break point - i think the class has a good understanding of the basics of .net controls and is ready for the db stuff. the good news is we have a complete half of a semester to review this, which is great as it is very important and some of it can be involved. the students have a good foundation though, and we have the time. i think each term i do more in this class - which might make it tougher on the current students, but i think ultimately it is good...
