Can someone check our entity relationship diagram?
Hello! I just wanted to ask if someone could check our Entity Relationship Diagram for our project. We are students and are still quite new to database management systems. We would like to know if the diagram is correct and if there are any errors that need to be revised.
Here is the scenario that we are trying to create. I also included the draft of our diagram.
Scenario
A mobile application named RandomBite that allows the user to randomly select recipes from the list of recipes that is available in the application, as well as review recipes.
The database needs to track users (home cooks), recipes, and ingredients. Each user is identified by a user ID, username, password, email address, and full name. Each recipe has a recipe ID, name, a description, instructions in text form, instructions in audio form, instructions in video form, and an image of the final product. All media forms of the instructions are present at the same time. Lastly, each ingredient is identified by an ingredient ID and a name.
Each recipe consists of one or more ingredients and is identified by the quantity of ingredients that is included in a recipe. A user can randomize one or more recipes. A user can also review one or more recipes by giving a rating and a text of the actual review.
ER Diagram: