Recipe Database

• 

  Types of Dishes

• 

  Recipe Table

• 

  Ingredients Table

• 

  Retrieve all recipes for a specific type of dish (e.g., Main Dish)

• 

  Retrieve recipes with a rating higher than 4.5

• 

  Retrieve recipes ordered by their ratings in descending order

• 

  Adding new recipe to the database

Inspiration

The inspiration for creating a recipe database often stems from a passion for cooking, a desire to organize and share culinary creations, and the need for a centralized resource for storing and accessing recipes.

What it does

The Recipe Database serves as a centralized platform for storing, organizing, and accessing culinary recipes. It allows users to:

Store Recipes: Users can input and store their favorite recipes, including details such as ingredients, preparation methods, cooking times, and ratings.

Organize by Type: Recipes can be categorized by type of dish (e.g., Main Dish, Dessert, Salad) for easy browsing and retrieval.

How we built it

Built the Recipe Database using SQL for data storage

Challenges we ran into

Ran into challenges with database schema design, especially relating to relationships between tables.

Accomplishments that we're proud of

Proud of creating a user-friendly recipe database with comprehensive search features, robust data

What we learned

I learned database design principles, SQL optimization techniques, and data validation practices.

What's next for Recipe Database

I will add more data. Make a project related to a recipe or food using HTML/CSS/JS for the front end and node js in the backend to utilize the database I created today

Built With

• mysql
• sql