Not sure about prizes yet. I have Open Query pencils (recycled newspaper) and they’re transactional with rollback (the eraser 😉 but perhaps I’ll come up with something else for this. Anyway, your challenge, should you choose to accept it, is:
Design a MySQL schema, and show me some sample queries (to prove your design works), for doing the following. Given a database of recipes that each contain a number of ingredients, I want to crossmatch this against what I have in my pantry/fridge/cocktailcabinet and find out which recipes I can actually make!
Depending on how you do it this may not seem too complicated; then go to the next step with possible substitute ingredients. This happens both with cooking as well as with cocktails. Devise some kind of equivalence magic (like a soundex for ingredients 😉
Enjoy! Have some nice chocolate eggs too.
I’m going camping with my daughter Phoebe, who is nearly 3 years old now.
It wouldn’t be fair to post the answer as my own, so instead, I’ll give a link to it
http://www.artfulsoftware.com/infotree/queries.php#90
(at least answers the first part of the challenge)
[…] before the Easter holidays I posted this challenge for a MySQL schema. For lack of submissions to far, I’ll leave it open for a little bit […]