Question: Design the database for a diet tracking study: Each recipe has an ID , name, food type ( soup , dessert, etc ) , cuisine,

Design the database for a diet tracking study:
Each recipe has an ID, name, food type (soup, dessert, etc), cuisine, directions, serving size, and amount per serving for calories, fat, cholesterol, sodium, carbohydrate, and protein.
Each recipe has a list of ingredients with corresponding amounts. All recipes must have at least one ingredient.
Each ingredient has an ID, name, and amount per 100 grams for calories, fat, cholesterol, sodium, carbohydrate, and protein.
Each participant in the diet study has an ID. You need to record the participant's age group, gender, and ethnic group.
The tracker will record what food they eat and when they eat during the study. The food can be a dish following a specific recipe or an individual ingredient.
Each consumption has a date and time, and amount.
draw a diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!