title: Good examples for teaching database design
body: <p>Does anyone have any good scenarios for teaching relational databases and SQL?  All the examples I can find are either trivial or have improbable domain constraints (like full name being unique).</p>
  
  <p>I'm especially trying to find some good examples for normalisation: tables that don't immediately fit 3NF and BCNF.  At the moment I'm using a different problem for each level.</p>
  
  <p>Of course, I'd also love good examples of badly designed databases, but it's a bit distracting until the fundamentals have been mastered.</p>
  
  <hr>
  
  <p>Thanks, some nice examples.  I've marked the student/class one as the answer as I think it's the best so far, but if anyone wants to contribute some more, please do.</p>