John Newman
Senior Project
Class: MCS4833
Sec: 01
Semester: Fall 2000
11-1-00
Student: John Newman

Project Title: The Brief Psychiatric Rating Scale System Database

Test Cases (20):

1) The single-point graph that represents an individual's symptom profile appears on
the same graph as the Diagnosis plots at start up.  (I ADDED THE LAST 3 WORDS WHICH IS
ADDED FUNCTIONALITY FROM LAST NON-DB VERSION)

2) The software highlights the psychiatric Diagnostic Statistical Manual (DSM) diagnosis 
text at the bottom of the screen that corresponds to the diagnostic reference point
that is closest to the plot of the individual's symptom profile.   

3) The user can update the individual's name.

4) The user can sort the profiles alphabetically according to the individual's last name.

5) The user can see the words "mild", "moderate" or "severe" displayed, when the total BPRS
score is calculated.  (i.e. This is a one-word verbal description of the individual's total
BPRS score based on certain ranges.) 

6) The user will be able to query the number of individual profiles in the database whose  
point would be graphed in the center square. (i.e. Clicking a command button will give the 
query result.  The center square is the zone wherein the individual's display of symptoms is
minimal usually.)  PLEASE DELETE THIS TEST CASE.  DR. FERRARI STATES THIS FUNCTIONALITY IS 
MEANINGLESS.  PLEASE REPLACE WITH:

6) The user will be able to select from one of a list of many english descriptions of SQL queries
that will be listed in a drop down box.

7) The user will be able to query the number of individual profiles in the database whose  
point would be graphed outside of the center square, elsewhere on the graph. (i.e. Clicking 
a command button will give the query result.  Points that land outside of the center zone 
correspond to symptom profiles of individual's with more severe symptoms.)
PLEASE DELETE THIS TEST CASE.  DR. FERRARI STATES THIS FUNCTIONALITY IS MEANINGLESS.
PLEASE REPLACE WITH:

7) The user will be able to see the query results in the Query Results grid after clicking 
the Run Standard Query Selected Above command button.

8) The user will be able to record more than one profile for the same individual in the
database.

9) The user will be able to perform ad hoc SQL queries of the database by entering SQL 
into a text box and then clicking a command button.

10) After clicking on the DSM diagnosis, the user will see "help" text displayed that 
describes the symptoms associated with that diagnosis according to the DSM. 

11) The user will be able to navigate through the database tuples by clicking on the toolbar
menu items.

12) The user will be able to edit records.

13) The user will be able to add records.

14) When the user is in record edit or record add mode, the editable boxes will change color.

15) The user will be able to delete a record.

16) The user will be able to change the symptom frequency for Axis 1 or 2 on the Symptoms
Qualifiers page from a drop down box.

17) The user will be able to see approximately according to a progress bar, how far the user 
is in navigating through the database.

18) The user will be able to see, in a label, the tuple number of a total number of records;
such as "5 of 10 records".  This indicates her/her exact location in the database table.

19) On the QueryForm, the user will be able to see, in a label, the count of the number of 
records returned from a query.

20) On the QueryForm, the user will be able to scroll through the query results in the direction
of rows / vertically.

21) On the QueryForm, the user will be able to scroll through the query results in the direction
of columns / horizontally.

22) On the main BPRS page, the names of the persons will be ordered alphabetically by LastName and
then by increasing profile number.