database
extensive testing
other tests & test log
In this section I will carry out five different tests on each entity to absolutely make sure that they both work correctly and efficiently:
Presence check...
Description: For the CD entity I will be testing the CD Number field, seeing as the field is always required. For the Order entity I will be checking the Order Number field seeing as this also is always needed.
| Entity | Expected Outcome | Actual outcome |
| CD | If the field is left blank an error message will appear. | An error message appeared saying: 'This field cannot contain a Null value.' So my estimation was correct. |
| Order | If the field is left blank an error message will appear. | An error message appeared saying: 'This field cannot contain a Null value.' So my estimation was correct. |
Overall result: Both the tables work correctly at this point.
Length check...
Description: The Artist field is being tested in the CD table and the Card number field is being tested in the Order table.
| Entity | Expected Outcome | Actual outcome |
| CD | The database will not allow the user to add more than 20 characters into the field. | The database did not allow the user to enter more than 20 characters into the field an error sounded at each attempt. |
| Order | The database will not allow the user to add more than 13 numbers into the field. | The database did not allow the user to enter more than 30 numbers into the field an error sounded at each attempt. |
Overall result: Both the tables work correctly at this point.
Data-type check...
Description: The two fields being tested are on the Order entity, this is because these are the only ones that are not the 'Text' data-type. The two fields are: Order Date and Expiry Date.
| Entity | Expected Outcome | Actual outcome |
| Order | The database will not allow the user to add text into the field and an error message will appear. | An error message appeared saying: 'The data you have entered is not valid for this field.' |
| Order | The database will not allow the user to add text into the field and an error message will appear. | An error message appeared saying: 'The data you have entered is not valid for this field.' |
Overall result: This test worked as expected, the database works correctly at this point.
Attempted modification of Primary Key/Foreign Key field data...
Description: I will attempt to modify the 'CD Number' field in both entities.
| Entity | Expected Outcome | Actual outcome |
| CD | The database will not allow the user to modify the data because the it is related to another record on another table. | An error message appeared saying: 'The record cannot be changed because the table 'Order' includes related records.' |
| Order | The database will not allow the user to modify the data because the it is related to another record on another table. | An error message appeared saying: 'The record cannot be changed because the table 'CD' includes related records.' |
Overall result: The database works effectively at this point.
Input mask check...
Description: I will try to save an incomplete record in each of the table's primary key fields.
| Entity | Expected Outcome | Actual outcome |
| CD | An error message will appear if the data is not compliant with the field's input mask. | An error message appeared saying: 'The value you entered isn't appropriate for the input mask...' |
| Order | An error message will appear if the data is not compliant with the field's input mask. | An error message appeared saying: 'The value you entered isn't appropriate for the input mask...' |
Overall result: The whole of database is definitely functioning correctly and efficiently.
Click next to continue...