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