Database_Testing

Database_Testing - Database Testing Testing Table Test...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Testing Testing Table Test Number Test Expected Outcome Actual Autcome 1 Validation rule: New Cust_Title, customer details field. Enter of the word Sir. The Database should not let me enter the word Sir and a validation rule should appear. The Validation rule appeared in the Window stating “You must enter Mr, Miss, Ms or Mrs”, This test was successful. 2 Is it possible to enter letters into the Card Number field in the customer details table? This should me prohibited as the Data type is set to Numeric characters only. An error message appeared and the letters were not entered into the field, this was a success and the data type validation worked. 3 Is it possible to change the Order date in the orders table? It should not be possible to change the date in the order date field as I have set up a validation rule to prevent this from been capable. As I expected a validation rule appeared and it was not possible for me to change the date, this was another successful test. 4
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/18/2011 for the course BS 1 taught by Professor Templas during the Spring '10 term at Chippewa Valley.

Page1 / 2

Database_Testing - Database Testing Testing Table Test...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online