The Goal You are being employed by a company that offers a fitness tracking service. They are working on a phone app that will allow the user to track what they eat, as well as when/how they work out. Another employee will be designing the user interface, but you are responsible for designing the database. Design an ER diagram to fulfill this goal, making sure to meet all of the requirements. Show all attributes, and label all identifiers. You must have an identifier for every entity present. 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).
• 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. Necessary Views 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).
• The user will search through the food database to find common foods, in order to track them.
• 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.