| |
- To check 1):
- ADD Customer with 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
Then enter the View/Update screen and change the appropriate fields to:
Last Name: Dwarf
First Name: Sleepy
Phone Number: 249-9898
Address: 666 Beast Street
City: Dullsville
Province: SK
Country: Canada
Postal Code: Q3P 5J8
Max Fines: 33.42
Max Books: 1
Expected Results -
After clicking on the UPDATE button, the above modifications will be accepted once the correct supervisor password is entered at the appropriate places.
- 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):
- ADD a customer with the following data:
Last Name: Dandy
First Name: Jim
Phone Number: (402)243-9898
Address: 1024 Sprinklewood Way
City: Shelbyville
Province: OK
Country: USA
Postal Code: 9010290901
Select the UPDATE button.
Expected Results -
A dialog box will appear informing you that there were no modifications made.
- To check 4):
- ADD a customer with the following data:
Last Name: Dandy
First Name: Jim
Phone Number: (402)243-9898
Address: 1024 Sprinklewood Way
City: Shelbyville
Province: OK
Country: USA
Postal Code: 9010290901
Then enter the View/Update screen and change the appropriate fields to:
Last Name: Dwarf
First Name: Sleepy
Phone Number: 249-9898
Address: 666 Beast Street
City: Dullsville
Province: SK
Country: Canada
Postal Code: Q3P 5J8
Quit the program and query the database to ensure that the record has been updated with the new information.
|