CS336 Summer 2006 Project Requirements

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) User Administration
   create account for Doctor, Patient, AdministrativeStaff
   login/logout
2) Patients:
       - Search for doctors
       - Make/cancel/view appointment for doctor/lab-test
       - 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)
       - View Lab Results
4) AdminStaff:
       - Make/Cancel/view appointment
       - Management of medical records
       - Order medicine from pharmacy
       - Add new doctor/patient
5) Superuser: create accounts for AdminStaff


Advanced requirements (20%)

1) Patients order medication (should be matched with prescribed medication)
2) Develop any 2 Triggers for example
  - alert doctor about some abnormal lab result for one of her patients
  - alert staff about need to order medication because stock is low
  - when doctor/staff cancels appointment, patient is notified by
  email [fake this by having a table for email messages]
3) 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.