Description

CSCI466Assignment1
ERDiagram-FitnessTracker(50pts)
TheGoal
Requirements
• Every user will have an account, and all of their meals and workouts will be linked to this account.
• To track weight loss, the user will update their weight periodically. This data must be retained.
• The serving size will be some number of units (grams, ounces, Tbsp, cups, lbs, etc.). There will be information stored for conversion between different unit types.
• There will need to be a database of foods/beverages. Each of these will have information on serving size, calories per serving, and grams per serving of each of the macronutrients (protein, fat, carbohydrates). • It should be possible to store information on the quantities of micronutrients or chemicals (i.e. vitamin D, caffeine) that are present in a given food or beverage in significant amounts. Recommended daily values for any of these should be stored, when applicable.
• Each time the user eats, a record of who ate how many servings of what and when is stored.
• The app needs to allow a user to track their workouts. This includes the type of the workout, its intensity, and its duration.
• When a user tracks their workout, a record is created of who did what type of workout, when, and for how long.
Note: If you are not sure what needs to be included for foods/drinks/etc., a good place to look for example data would be the nutritional facts on food packaging.
NecessaryViews
The database needs to be able to store its operational data in such a way that the final app will be able to show the following views (at minimum). You don’t need to implement the views, but the necessary data should be modeled.
• A graph will be generated of how many calories a user consumed each day of the week.
• A similar graph will be generated that shows how many calories were burnt each day of the week through workout.
• Show a pie graph of the percentage of the diet made up of each macronutrient during a given time period (day, week, month).
• Track the consumption of a given micronutrient/chemical over a specified period of time. If there is a recommended daily value, show a comparison of their consumption with the recommended amount.
• Allow the user to search through the food database to find common foods, in order to plan their diets. These same foods will be used to track their eating.
• The user will search through a list of workouts to find the one closest to the one they’re going to do, in order to track the activity.
• A line graph of user weight over time.
CSCI466Assignment1 2 of 2

Whattoturnin?
You should turn in, via Blackboard, the following:
• A text file or another PDF that explains all entities and relationships you’ve chosen to use, along with a description of each of their attributes. List any assumptions that you will have made when deciding cardinalities that are not specified explicitly by the requirements.