codeseed
Sign in
Explore Projects
SQLbeginnerbackendAI generated

Personal Recipe Box Database

Model a database of recipes, ingredients, and the many-to-many relationship between them, then write queries to find recipes matching a set of ingredients on hand. Learners practice many-to-many junction tables, joins, and GROUP BY/HAVING filtering.

Estimate
~7h
Steps
5
Completed by
0
Proposed by
codeseed.app

PostgreSQL · pgAdmin

Sign in to claim this project

Project roadmap

  1. 01

    Design the schema

    ~1.5h

    Create recipes, ingredients, and a recipe_ingredients junction table with quantities.

  2. 02

    Insert sample data

    ~1h

    Add a variety of recipes and ingredients, linking them through the junction table.

  3. 03

    List ingredients per recipe

    ~1.5h

    Write a join query showing each recipe with its full ingredient list.

  4. 04

    Find recipes matching available ingredients

    ~2h

    Use GROUP BY and HAVING to find recipes fully covered by a given set of ingredients.

  5. 05

    Filter by cuisine and prep time

    ~1h

    Write a query filtering recipes by cuisine type and maximum preparation time.

Resources

Ready to build this?

Get a GitHub repo and start building. Your AI reviewer checks each step as you go.

~7h · 5 steps

Tech stack

PostgreSQLpgAdmin