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?

Organizational Impact	Value	Metric	Time Frame
Strategic	Increase the product awareness and brand image ? ? Penetrate new target market	Increase market share from 20% to 40% Increase nutrition advice features from 50% to 70% Include restaurants, supermarkets as new users	24 months ? 12 months ? 12 months ?
Customer	Receive better services and comprehensive nutrition advices	Reduce journal data entry procedure from 5 steps to 3 steps At least 5 nutrition tips per day compared with 2 originally Nutrition advices come from diet, sport and medical three aspects compared to 1 originally	6 months ? 6 months ? 6 months ?
Financial	Increase revenue ? ? Reduce cost of regular updating database	Charge $5 monthly each customer will increase revenue by 15% $0 food database updating cost any more	24 months ? ? 6 months ?
Operational	Eliminate process of updating food database	No food database update process which will done by restaurants and supermarket themselves	6 months ?
Social	Increase awareness of healthy life style	Increase No. of customer by 20%	24 months ?

The original existing nutrition systems of the company provide customer the general functions which could also be found in other competitors’ products. As our proposed new features added nutrition system launches, the outstanding specialty would attract new customers to increase market share from 20% to 40% based on original pie, which would be achieved within 2 years. And, as new type of users involved in our proposed system, target market will penetrate into restaurants and supermarkets.

By improving the data entry efficiency of reducing the input procedure from 5 to 3, and giving more nutrition tips and reminders, our proposed system would definitely become more and more attractive. Moreover, we change our charging type from software renting payment one time forever to monthly payment. The overall revenue would increase by 15% in 2 years’ time.

As restaurants and supermarkets taking part in our proposed system, they’ll update their food database regularly all by themselves in order to attract customers for competition, we eliminate the database updating process, which would decrease the maintaining cost and data updating errors that would increase the efficiency of system’s operation.

From social perspective, the more customers using our system, the more aware of healthy life style in the society. This is our prospect in long-run.

Dear all,

I have post the discussion result of Project Mgmt case, the file name is "Case Discussion.rar" in the "File part."

Thanks,

Luke