- To check 1):
- input:
Last Name: Dandy
First Name: Jim
Phone Number: (402)243-9898
Address: 1024 Sprinklewood Way
City: Shelbyville
Province: OK
Country: USA
Postal Code: 9010290901
Expected Results - Customer added to database without error once the ADD button is pressed.
input:
Last Name: Dandy
First Name: Jim
Phone Number: (402)243-9898
Address: 1024 Sprinklewood Way
City: Shelbyville
Province: OK
Country: USA
Postal Code: 9010290901
Max Fines: 10.00
Max Books: 25
Expected Results - Customer added to database without error once the ADD button is pressed and the correct supervisor password is supplied.
- To check 2):
- All individual field testing will assume that all other fields are syntactically correct.
| Error Condition(s) |
Input To Test |
|---|
| Last Name: |
|---|
| a) field empty |
|
| b) too long |
string more than 60 characters |
| c) invalid characters |
Dan*y9(, |
| First Name: |
|---|
| a) field empty |
|
| b) too long |
string more than 40 characters |
| c) invalid characters |
J-m^ |
| Phone Number: |
|---|
| a) field empty |
|
| b) doesn't match template |
(23)543-9089 9087 452 |
| Address: |
|---|
| a) field empty |
|
| b) too long |
string more than 80 characters |
| City: |
|---|
| a) field empty |
|
| b) too long |
string more than 20 characters |
| c) invalid characters |
Kalamaxo97 |
| Province: |
|---|
| a) field empty |
|
| b) too long |
string more than 2 characters |
| c) invalid characters |
A) |
| d) too small |
string less than 2 characters (eg. "A") |
| Country: |
|---|
| a) field empty |
|
| b) too long |
string more than 10 characters |
| c) invalid characters |
Kanad# |
| Postal Code: |
|---|
| a) field empty |
|
| b) doesn't match template |
T3E 65H K90159B3 |
| Max Books: |
|---|
| a) invalid characters |
3* 10.5 3e |
| Max Fines: |
|---|
| a) invalid characters |
3*.75 3e.00 |
|
Expected Results - A message box will indicate in what fields the error(s) occurred and the customer is not added.
- To check 3):
- input:
Last Name: Dandy
First Name: Jim
Phone Number: (402)243-9898
Address: 1024 Sprinklewood Way
City: Shelbyville
Province: OK
Country: USA
Postal Code: 9010290901
ADD this customer, then QUIT the add customer screen and then reenter the Add Customer screen and reenter the above customer once again.
Expected Results -
The Customer Search window will appear with the duplicate customer in the list.
- To check 4):
- input:
Last Name: Dandy
First Name: Jim
Phone Number: (402)243-9898
Address: 1024 Sprinklewood Way
City: Shelbyville
Province: OK
Country: USA
Postal Code: 9010290901
ADD this customer, then QUIT the program and directly query the database to see if this record exists.
Expected Results -
The query will reveal that the customer is in the correct datastore.