Nutrition Tracking Database

Description

Project Description:
µtrition 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.®bsp;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.

Data model & design:
o Completed ER/EER diagram, 5 tables minimum.
? MUST use https://www.draw.io to draw the ER diagram, and then take a snapshot.
? 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.

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:
?  Snapshot of the code and the output in the report.
? In about 2 lines, explain what the query returns.
Queries:
? 1 trivial query. Simple select with ordering.
? 2 medium difficulty queries. Queries that use composite condition for selection, computations,
aggregate function and grouping.
? 1 query that uses subquery.
? 2 queries that uses join (1 inner join, 1 left or right outer join).
? 1 view (query must use join ®bsp;hint: you can use one of the queries from the previous question).
? 1 query that uses union.
? 1 custom stored function.

? 1 custom stored procedure.

2 attachments

Slide 1 of 2

attachment_1

attachment_1
attachment_2

attachment_2

Unformatted Attachment Preview

4) Implementation:
A snapshot of the SQL code
Queries:
1 trivial query. Simple select with ordering.
This query list the parents last name by the order.
2 medium difficulty queries. Queries that use composite condition for
selection, computations, aggregate function and grouping.
i.
These queries display the selection of teachers who teaches English.
ii.
These queries display the selection of teachers who teaches math.
1 query that uses subquery.
These queries display the number of failed students.
1 query that uses union.
These queries display the common data between two table.
1 view (query must use join (int: you can use one of the queries from
the previous question).
2 queries that uses join (1 inner join, 1 left or right outer join).
Inner join
This query display the common elements of the two table.
Left join
This query joins the rows from left table.
1 custom stored function.
This query uses the salary stored function.
1 custom stored procedure.
This query displays the custom (getallstudent) stored procedure
References
Data, M. H., & User, G. (2015). Database Design. Perancangan Basis Data) merupakan salah
satu.
Leone, S., Hunt, E., Hodel, T., Bb%n, M. H., & Dittrich, K. R. (2006, September). Design and
implementation of a document database extension. In CEUR Workshop Proceedings (pp.
144-157). Alexander Technological Educational Institute of Thessaloniki.

Purchase answer to see full
attachment

Explanation & Answer:

3 pages

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.