Posted on 2 Comments

Easter Challenge: design db for cooking/cocktail recipes

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.

Posted on 2 Comments

2 thoughts on “Easter Challenge: design db for cooking/cocktail recipes

  1. 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)

  2. […] 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 […]

Comments are closed.