[tommaho]

The Kimball book series suggests some generalized schemas by industry, for the purpose of data warehousing. Here the academic schema rules tend to bend a bit - denormalization can become a useful and often necessary technique, for example.

Might be helpful for a rounded understanding of good schema design - it can depend on the context.