Aunt Adelina's cookbook

Task

We want to help our aunt Adelina to organize her recipes.

Beside the name of the recipe we want to store two texts and an image: the first text is a list of ingredients and the second text is the preparation method. We also want to display the difficulty of the recipe (range 1-5), the preparation time and the average cost.
In addition to this, the database must store information about the chef who invented the recipe - aunt Adelina is fascinated by this aspect. She wants to be able to find the chef's name, surname and picture.

Design an entity-relationship diagram, a relational schema and an instance of the database.

Create also the queries which will return:

1. a list of the names of the recipes sorted by difficulty (the most difficult first).
2. a list of the names of the recipes, the preparation time, the chef's name and surname. The recipes will be ordered by preparation time (from the quickest).
3. a list of the pictures for all the recipes which cost on average less than 10 euros. The picture of the recipe will be accompanied by the picture of the chef who created it.
4. a list of all the chefs' surnames and names ordered alphabetically.
5. a list of the ingredients of all the recipes created by the chef "Antonino Cannavacciuolo".