Food Blog Backend

You will create a simple backend that will allow you to populate an SQLite3 database. You will find out how to
deal with an auto-increment primary key and how to use foreign keys to create relationships between tables.
You will learn to work with many-to-many relations, with SQL queries, and with database cursor methods.

Your great-grandmother asked you to copy all the recipes that she had been collecting in her notebook for several
decades to “that computer of yours”. You don't like easy solutions, so you decided to build a recipe database.
You will need to refresh your SQL knowledge to build a simple backend.

Stage 1/5: Create dictionaries

Create a database and prepare the dictionaries.

Stage 2/5: Time for recipies!

Create the main table and a simple recipe entry tool.

Stage 3/5: Many-to-many relations

Create an intermediary table to deal with many-to-many relations.

Stage 4/5: Too many ingredients!

Create a table to store quantity, measure, and ingredient names. You will also need to implement ways
to speed up the database completion.

Stage 5/5: First interface

Create your first backend interface that will allow you to return the data you are looking for.