Criterion B (Designing)
Design Specification
This design specification will provide information about the
cancer drugs and the various details such as manufacture date, expiry date,
brand name, etc.
The database will have two tables which will contain
information about the cancer drugs and patient details, who are buying the
drugs. For this, queries, reports and forms will be made based on this
information. Forms will contain a few features such as tab control, hyperlinks,
auto-dialer, exit, option group, list box and buttons which will make it easy
for the user to work on the database. There are also a few validation rules
which will reject unnecessary data.
There is also a menu interface and several buttons to select
options which will guide the user step by step. It will also take the user to
different areas such as cancer drug information, patient details, etc.
I have used a few different features in my Microsoft Access
Database. They are the following:
Features
|
Justification
|
Key Field
|
To identify a specific record.
|
Picture Box
|
Inserted box which displays the image of the drug/patient.
|
List Box
|
Displays a list of values or choices. It is similar to a combo box
but contains rows of data.
|
Buttons
|
To select different options such as close form, save record, etc.
|
Tab control
|
Consists of different pages where you can add features such as
buttons, hyperlinks, etc.
|
Option group
|
Allows the user to select an option.
|
Queries
|
Displays broken down data from different tables such as details about
drug, prices, etc.
|
Forms
|
I have three forms in my database. Displays data from tables.
|
Reports
|
Display a summary of data.
|
Tables
|
There will be two tables which will display the data for cancer drug
information and patient details.
|
Combo Boxes
|
Allows the user to select an option.
|
Validation Rule
|
Allows only necessary data to be added into the table.
|
Validation Text
|
If unreasonable data has been entered into the table, then this
feature will display an error message.
|
Security
|
This will secure the database with the help of a password only.
|
Plan for Cancer drug
information table:
Field Name
|
Datatype
|
Width
|
Example
|
ID
|
Number
|
|
75238749
|
Name
|
Text
|
20
|
Rituximab
|
Brand Name
|
Text
|
20
|
Rituxan
|
Manufacture date
|
Date/Time
|
|
4/7/1998
|
Expiry date
|
Date/Time
|
|
4/7/2015
|
Type (s) of Cancer
|
Text
|
255
|
B-cell non-Hodgkin lymphoma
and chronic lymphocytic leukemia
|
Approval of FDA
|
Text
|
3
|
Yes
|
Composition
|
Text
|
255
|
|
Price
|
Currency
|
|
$708.17
|
Quantity
|
Number
|
|
2
|
Validation rules,
texts and other functions have been added from the following table:
Field Name
|
Validation Rule
|
Validation text
|
Input mask
|
Name
|
Is Not Null
|
Please enter name of drug
|
>L<?????????
|
Brand name
|
Is Not Null
|
Please enter brand name of drug
|
>L<?????????
|
Approval of FDA
|
“Yes” Or “No”
|
Enter Yes or No only
|
|
Dosage (per day)
|
>=0 And <=10
|
Enter 0-10 only
|
|
Field Name
|
Display Control
|
Row Source Type
|
Row Source
|
Dosage (per day)
|
Combo Box
|
Value list
|
0;1;2;3;4;5;6;7;8;9;10
|
Approval of FDA
|
Combo Box
|
Value list
|
Yes;No
|
Plan for the patient
table:
Field Name
|
Datatype
|
Width
|
Example
|
ID
|
Number
|
|
343242132
|
First Name
|
Text
|
20
|
Gabriel
|
Last Name
|
Text
|
20
|
Watson
|
Gender
|
Text
|
1
|
M
|
Nationality
|
Text
|
20
|
American
|
Disease
|
Text
|
20
|
Liver cancer
|
Preferred drug/therapy
|
Text
|
20
|
Chemotherapy
|
Contact No.
|
Text
|
10
|
2332424234
|
Quantity
|
Number
|
|
3
|
Picture
|
OLE Object
|
|
|
Validation rules and
texts have been added from the following table:
Field Name
|
Validation Rule
|
Validation Text
|
Input mask
|
First Name
|
Is Not Null
|
Please enter name of patient
|
>L<????????
|
Last Name
|
Is Not Null
|
Please enter last name of patient
|
>L<????????
|
Contact Number
|
Is Not Null
|
Please enter contact number of patient
|
>L<?????????
|
Gender
|
“M” Or “F”
|
Enter M or F only
|
|
Quantity
|
>=0 And <=10
|
Enter 0-10 only
|
|
Field Name
|
Display Control
|
Row Source Type
|
Row Source
|
Gender
|
Combo Box
|
Value List
|
M;F
|
Quantity
|
Combo Box
|
Value List
|
0;1;2;3;4;5;6;7;8;9;10
|
Layout of Database:
Form (Design1):
Form (Design 2):
Evaluation between Form
Designs 1 and 2:
I prefer design 2 rather than design 1 because:
·
there are
more buttons which allows the user to add, delete, duplicate or save records especially
close forms.
·
There is an option group which allows the person
to select yes or no.
·
This design also gives the picture of that
particular drug.
·
There are two combo boxes which allows the user
to select which value.
·
An attractive logo.
·
In addition, this design also looks properly
organized with the cancer drug information.
Main Menu (Design 1):
Main Menu (Design 2):
Evaluation between Main Menu Designs 1 and 2:
I prefer design 2 rather than
design 1 as:
·
Consists of a tab control in which the user
could select anyone of the following from several pages.
·
Hyperlinks which can take the user only to
tables, queries and reports.
·
Buttons in the page named ‘Forms’ to open the
forms.
·
Button ‘Quit application’ which can allow the
user to exit the database.
·
Auto dialer allows the user to make phone calls
regarding urgent matters.
Patient Details (Design 1):
Patient Details (Design 2):
Evaluation between
Patient Details Designs 1 and 2:
I prefer design 1 rather than design 2:
·
There are two combo boxes which allows the user
to select his/her gender and the amount of medicines he is taking.
·
There is a list box which lists all the patient
ID’s records.
·
Displays the patient’s picture.
·
Has two buttons which allow the user to close
form or add records.
Security (Design 1):
Security (Design 2):
Evaluation between
Security designs 1 and 2:
I prefer design 1 rather than design 2. There is because
there is an encrypted security function which prevents access to people who are
trying to take your confidential work.
Flowchart for my
database:
Test Plan:
Now that I have made
my designs and created my database, I must test the end product and its
features. I will do this due to the following:
·
Buttons: Most of buttons must take the user to
the required and other buttons must work properly. E.g. Auto dialer which will
call anyone by entering a contact number.
·
Hyperlinks: They have to take the user to the
specified area. E.g. The Cancer Drug Information hyperlink must take the user
to that table.
·
Tab control: Look at different pages and make
sure that all the hyperlinks and buttons are there.
·
Validation Rules and Texts: I will test the
validation rules and texts. E.g. If unreasonable data is entered in the gender
section in the table, it will display “Enter M or F only”.
·
Security: When I open the database, an encrypted
password tab must open.
·
Picture Box: When I open a certain form, the
picture of the drug/patient must be displayed.
For the main part of this plan, I will test the validation
rules. Here is a table which talks about Gender. I will enter two values and
check whether my validation rules and texts are in motion:
Gender (Input Data)
|
Expected Result
|
Success or Failure?
|
M
|
-
|
Success
|
Fail
|
Enter M or F only
|
Success
|
