==================================================================
IDEA2-DBMS: 
==================================================================
  Createdby: LeongHonWai
  Date:      20-Oct-2003;
  Note:   With additional features in IDEA-2, the DB of IDEA
          will have to be extended -- and quite a bit too.
          We hope that changes will mean new things added --
          new values, new attributes, new tables.
          This document will only add *SOME* of the new things.
          There are lots of necessary changes not included yet. 
  Edit History:  

----------------------------------------------------------------
start of db-changes

PEOPLE:  (existing table)
  * perhaps have to add/use category 
       maybe change status to category
  * add in user-groups (each group -- a list of existing users)
      used in messaging, schedule, others....
  * add contact numbers, email, mygroups,...
  * birthday (already exists!)
  * status -- to mean in-house or not in-house;
  D: Add in person "visitor" and "unknown" and "stranger"
  D: Add in all the people in the class;
  D: Have selected test users; --- for testing purposes;


SCHEDULE: (existing table)
  * add category of schedule;
  * allow schedule for groups (need to be defined in PEOPLE)
  * add expiry dates;
  * add in reminder service;
  D: Add in some GOOD test messages of each category


MESSAGE: (existing table)
  * add category of message;
  * allow message to groups (need to be defined in PEOPLE)
  * add expiry dates;
  * allow deleted {marked, or actually removed}
  D: Add in some GOOD test messages of each category for test users;


WELCOME: (existing table)
  * greeting types; (general, birthdays, holidays, etc)
  * should voice message be added? (audio output as well?)
  D: Must add many, many more different welcome messages
       of each type --- and good ones too.


JOKE: (existing table)
  * add joke category (exist already?)
  * use joke-id for identification purposes;  (existing)
  D: Must add many, many more jokes of each category; 
   

LOG: (existing table)
  * Is there a need to have different types of log files?
      -- entry/exit log; error log for DB; GUI; Controller; FeatureEngine


HOLIDAYS: (new?)
  * list of public holidays; (this could be modified from WEL_DATE of WELCOME)
  * could also be used for other holidays (if have type of holidays);
  D: Must put in all the holidays (public and NUS) for 2003-5.

PREFERENCES: (new)
  * default action on Entry and Exit;
     - default welcome message;
     - default joke category;
  * preferred door colour;
  * preferred settings for message;
  * preferred settings for schedule;
  * list of recently told jokes;
  D: Enter this for ALL users!!
  D: For test users, have different preferences for illustration;


CAMERA-DB: (new?)
  *** not sure if this is needed ***
  * database for the camera?
  * does the camera have its own database of users?
  * voice-message (if camera can activate speaker!)


SPEAKER: (new?)
  * default volume setting;
  * voice-messages and types and ???


end of db-changes
---------------------------------------------------------------------------


DBMS: New Features (to be added)

To build customized database management sub-system that will be 
used to maintain ALL the tables in the database; with simple
clickable web-based "menus" to  
  * list all tables, 
  * list selected table,
  * show specific records,
  * update specific records,
  * add new records,
  * check consistency across the DB;