subject

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.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 18:40
Access defaults to searching for information on the
Answers: 1
question
Computers and Technology, 22.06.2019 14:40
You are working with a professional edition organization. they wish to install the expense tracker which requires the use of 4 custom tabs, 3 custom objects, and one custom app. if the company is already using 4 applications, 36 custom objects, and 7 custom tabs, what will happen when they try to install expense tracker?
Answers: 1
question
Computers and Technology, 22.06.2019 19:30
The following is an excerpt from a slide presentation. today we will inverse operations solving equations using inverse operations solving inequalities using inverse operations from which part of the presentation does the slide most likely come from? a. introduction b. outline c. body d. conclusion
Answers: 1
question
Computers and Technology, 23.06.2019 00:40
Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why.a.) student.course.callnum = "csc230"; b.) cin > > student.name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student.name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist.course.credits = 3; j.) course = studenttype.course;
Answers: 1
You know the right answer?
The Goal You are being employed by a company that offers a fitness tracking service. They are workin...
Questions
question
History, 28.06.2020 23:01
question
Mathematics, 28.06.2020 23:01
question
Business, 28.06.2020 23:01
question
Mathematics, 28.06.2020 23:01
question
Mathematics, 28.06.2020 23:01
question
Mathematics, 28.06.2020 23:01