geaux getters diabetes database

GEAUX GETTERS

DIABETES DATA

BASE

I S DS 3 1 1 0 - S U Z A N N E P A W

L OW

S K I

S E C T I ON 1

J A S ON B Y R D

– K E V I N T R A N – MI K E S E M

K O – D E ’ J O

N D I C K E R S O N –

B R A D WE E K S

DESIGN: ERD DIAGRAM

TABLE DESIGN - RELATIONAL SCHEMA

Here we have the relational schema as it appears in the database

DATA DICTIONARY

INTRODUCTION: USES OF DATABASEThe main uses of the database is to keep track of:• Glucose levels

• Weight over time

• Caloric intake

• Medication dosage amounts

• Types of food eatenMain user welcome screen

DATA ENTRY FORMS – ENTER NEW DATA

Upon navigating to the “enter new data” form, users are greeted with a main log screen which includes:

• Medication Log

• Weight Log

• Glucose Log

• Food Log

MEDICATION LOGHere, patients are able to enter their medication type and other fields that are required are:

• Date medication was taken

• Time medication was taken

• Dosage

• Delivery Method (oral, injection, or pump)

WEIGHT LOGOn the weight log form we have:

• USER ID

• Date weight is logged

• Weight being logged

From this table, a user can generate averages and keep track of their weight over time

GLUCOSE LOGUnder glucose log, we have the date and time in which the data was logged. Other required entries are:

• Amount of glucose recorded in user’s body

• Ketone levels (lower is better)

• Test type (fasting, post prandial, random)

FOOD LOGIn the food logs form, the user selects their USER ID, followed by the date and time in which the food is logged. Entries include:

• Food eaten

• Number of servings

• Which meal (Breakfast, Lunch, Dinner, Other)

VIEW REPORT SCREEN On the welcome screen, there is also a view report button that brings the user to a summary of reports that conveniently show different reports a user can print out

• Glucose levels

• Total carbs: with ketones present

• Total Carbs: Post prandial out of normal limits

REPORT #1 – GLUCOSE LEVELS • Amount of glucose

• Whether ketones are present

• Type of test performed

• Red = Low• Green = Normal• Blue = High

REPORT #2 - On report #2, we have a listing of the days in which ketones are present, as well as the daily total carbs that the user took in for that day.

REPORT #3 – TOTAL CARBS POST PRANDIAL

Report #3 shows the dates in which levels after the meal are out of normal limits, and again the total carbs that were taken. • The user can

use this information to later adjust how they eat their eating habits

REPORT #4 – WEIGHT / CALORIE TREND

Here we have a graphical report that shows the trends of both weight and calorie logs over time. On the non graphical report, there are averages of each trend

REPORT #5 - CALORIES AND FOOD EXCEEDING PRANDIAL LIMIT

Our last report deals with foods that exceed the prandial limit

• Food Type

• Date

• Total calories

DATABASE SECURITYMain Security Features include

• Restricted Access

• User Name / Password

• Guided Entries

• Access doesn’t allow user level security, but for the purpose of our database there can be multiple users. (user entity was created for further implementation)