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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
