I know this is a repeat of the post form Dan but as he is on MSDN and I am on TechNet blogs I think it goes to a slightly different audience.  I was asked about schema design by Andy from BETT 2007 where we did technical support for the Microsoft stand Eileen blogged about it previously.

Andy asked about sample schemas that they could use as a teaching tool.  We have released a whole set of schemas for SQL Express.  There were 10 when I looked last.  These give you a starting point and to support this there is a Webcast tutorial for beginners.  Each schema can be viewed or downloaded.  As a starting point I think these are really useful.