HCA537 homework
Name: MUNEER ALALI , and KHALIL ALBAIDHANI
Live longer App.
Description of system:
The app is a health management app that guides the user on healthy eating tips, work outs and gives statistics of the user lifestyle based on information the user feeds into the system. On installing the app, the user is required to provide their age, height, weight, gender and race. Based on this information the system does analytics and provides daily, weekly and monthly report of the user’s lifestyle in terms of exercising, how healthy their diet is and gives recommendation tips to improve on. The system will also give alerts on upcoming health seminars near the user. The system will also provide daily health news on upcoming medical research, medical breakthrough, health risks, and health warnings issued in case of disease out breaks
Mission statement
Better management of individual’s health through daily diet and exercise management.
Mission objectives
i. Collection of daily health lifestyle
ii. Provide analysis of individual’s health lifestyle
iii. Offer tips on improving individual’s health based on their health lifestyle.
iv. Act as an information tool to keep individual updated on upcoming health events.
v. Keep the user informed of developments in the health sector.
Entities and attributes of the system.
i. User
User attributes – user_id int primary key auto_increment names string, gender bit, height int, weight int, race string, and age int, email string, password string,
ii. Diet_lifetsyle - diet_id int primary key auto_increment,diet string, water_consumption int,time_of_day datetime
iii. Exercise_lifestyle - excercise_id int primary key auto_increment, exercise string, exrcise_hours, time_of_day datetime,days_per_week int
iv. Lifestyle_Analysis – lifestyle_id int primary key auto_increment,tip string, summary string
v. Upcoming_events_Tips – upcomingEvents_id int primary key auto_increment, location string, description
vi. Health_tips – health_tips_id int primary key auto_increment ,description string,tip fk
Live longer App ER Diagram
USER
names string
gender bit
height int
weight int
race string
age int
email string
password string
Diet_lifetsyle
diet string,
water_consumption int,
time_of_day
datetime
gg
Feeding
Lifestyle_Analysis
summary string
Health_tips
description string,
tips fk
Exercise_lifestyle
Exercise string,
exrcise_hours,
time_of_day datetime,
days_per_week int
Entity Relationship explanation
Exercising
Upcoming_events_Tips
location string,
description string
Recommending
Reviews
To attend
User and diet_lifstye – this is a one to many relations. One user has several diet programs in a day.
User and exercise_lifestyle – this is also a one to many. The user may have different workouts.
User and lifestyle_analysis – this is a one or many relationship. The user may have one or several lifestyle improvement recommendations.
User and healt_tips – this is a one or many relationship where the user may get one or several health tips
User and Upcoming_events_tips - this is a one or many relationship where the user may get one or several health events tips