BISLCSS - FYP team from University of Macau

The following two databases are on the Web Server

Ø       User Account Database

u        User Information Table //user’s basic information

u        Disease Record Table // record the user’s disease information

u        Food Journal Table // record the user’s daily food information, including the supplement information, and this table will be renewed every half year.

u        Daily Summary Table // = [user + day + all nutrition factors], it’s the summary of Food Journal Table

u        Workout Journal Table // record the user’s daily workout information

u        Favorite Food Table // restore the Top 10 popular food of the corresponding month

 

Ø       Default/Pre-stored Database

u        Food // all nutrition factor

u        Disease // [sensitive factor + disease name], it matches the sensitive factor and disease

u        Restaurant // dish information, updated by each restaurant

u        Workout // all workout and exercise information

u        Supplement // supplementary nutrition factor, such as Vitamin C…

 

There is another database on the PDA side to store the corresponding user’s information, which includes the following tables.

u        User Information Table

u        Disease Record Table

u        Food Journal Table

u        Food Plan Table // the user can set his plan beforehand, if he forget to enter journal, system will apply the Food Plan

u        Food Calories Table // download from server, includes all the food calories, = [Food + Calories]

u        Sensitive Food Table // this is searched from server side, Disease Table. It records the user is sensitive to what factors.

u        Pill-taking Table // record the user’s pill-taking schedule

 

PDA side database stores the corresponding user’s information only. Server side database stores complete information.

1. New service, including food comparison, food recommendation, eating pattern
    by Crystal
2. The restaurant part
    by Luke
3. draw prototype, only draw the basic information like what kind of information will be collected in the page
    by Sylvia
4. Questionnaire
    by Sean

Questionnaire

Introduction part: describe the software (IS)

The scope of the users

1. Do you have PDA, or do you want to buy a PDA device in the coming years?

2. If you have PDA, are you willing to use the software?

(2. To restaurant: do you want to use the online service of this IS)?

Personal questions: incoming, job, disease?

3. Have you used such IS?

4. Do you want to use an IS to remind you to take pills?

5. Do you want to use an IS to track your food information?

 

6. We have proposed the following functions in IS:

(Give the rank to each function) – (the functions listed here)

6.1 There is a function (Eating Patten Recommendation) – (describe this function in brief), do you want to use this function?

6.2 …

6.3 …

…

…

 

7. How much do you want to pay for such IS if you buy? – list the range of fee

8. How much of the monthly fee you can accept? (List the functions in Q.6.X – online functions) – list the range of the charge fee

8. Recommendation to the IS

       Any new features you want?