hi
Interesting book especially the stored procedures. I'd be interested to hear from anyone who is interested in extending or generalising the database; thus creating more variables to search upon. After all, not all of us want to sell coffee do we? I'm especially interested in filters or searching by specific categories see:
http://acookson.org/wp-content/uploads/2013/01/shop-screenshot.png
for an example of what's on my mind.
In my fictitional jeans shop example, I was playing around with MySQL workbench to come up with some possibilities for an ER diagram:
http://acookson.org/wp-content/uploads/2013/01/ecommerce3.png
It's totally at prototype stage and was looking for some inspiration really; maybe an on-going discussion around this topic.
best wishes
Andrew