CS336 Summer 2006 Project Requirements (Revised)

Basic requirements (80%)

The system is meant to support a group of doctors (working out of some
office). Each patient has his own primary doctor, but in urgent cases,
a doctor can cover for another one.


1) AdminStaff:
       - Add new doctor/patient
       - Make/Cancel/view appointment
       - Management of medical records

2) Patients:
       - Search for doctors
       - Make/cancel/view appointment for doctor
       - View prescription
       - View medical record
3) Doctors:
       - Cancel/view appointments (possibly organized in a variety
           of ways)
       - Prescribe medication for a patient
       - Manage a patient's medical record: look at it, add dated
   entries (some are text notes, others are things like when visits
   took place or what medications have been prescribed can be deduced
   from other aspects of the user interaction)
      

Advanced requirements (20%)

1) Develop any 2 Triggers for example
  - when doctor/staff cancels appointment, patient is notified by
  email [fake this by having a table for email messages]
2) Other features (be creative)

For projects which do not have appointment scheduling features, it is
assumed that something equally complex, having to do with billing,
insurance, and stock management will be undertaken.