Reference no: EM133399574
Project Description:
"Nutrition tracking is the process of collecting and analyzing qualitative or quantitative data on your dietary intake patterns, typically for the purpose of achieving health-related or fitness-related goals." Intake In this project, you will design and implement a nutrition-tracking database. This database will help the users to track the food and drinks they consume. The stored data includes but not limited to, food names, quantities, calories, consumption date and time, workout sessions and any other information you find related to the project.
Part 2: - Project Implementation
Report 2 Contents:
1) Project goals.
2) Database description: A general description of the database, what data is stored in the database. How the
database will benefit the users.
3) Data model & design:
o Completed ER/EER diagram, 5 tables minimum.
• Include a snapshot of the diagram in the report.
o Business rules.
o Data dictionary: For each one of the tables, list columns, data types, column restrictions, column
descriptions.
4)Implementation:
o Use MySQL Server and MySQL Workbench to create the database/tables.
• Include a snapshot of the SQL code in your report
o Populate the each table with a minimum of 20 rows of sample data. Make sure the entered data is descriptive (not just random numbers and letters.
• Include a snapshot of the SQL code in your report.
o Use MySQL Server and MySQL Workbench to write/run all of the SQL queries below. For each query,
provide the following in Report 2: