Description

Lecturer: Dr. Kevin Miller
Problem Definition – Part 1
You are contracted to design and implement an online meal planner and recipe system. In this system, the users should be able to do the following:
– Sign up for accounts
– Enter basic profile information
– Add recipes
– Plan meals for the week (Breakfast, Lunch & Dinner)
– Generate a supermarket list based on the planned meals
– Keep track of available ingredients in their kitchen
– Keep track of the calorie count for the planned meals
– Request the creation of meals based on specified calorie count
– Upload images of the meals
– Input servings for each meal
The system should be able to randomly create only 1 meal plan for the week. However, users should be able to regenerate this meal plan at anytime.
The list of ingredients should be taken from a predefined list, so users should not be able to insert ingredients that does not exist in the system. Likewise the measurements should also be predefined.
eg. 1⁄2 Cup Milk
In the example above, Cup and also Milk should be checked against a list in the database.
All the instructions for a recipe should NOT be stored in one (1) field.
All the ingredients should NOT be stored in one (1) field.
Convert the E-R diagram into a set of relations/tables.
(NB: Do not attempt to normalize your tables at this time.)
No late assignment will be accepted.
A submission container will be made available at the appropriate time.
The document (including the ER diagram) must be prepared using any relevant software.
You must keep a copy of the ER diagram as you will need it to do the next part of the project.
**** THE END ****