That Blue Square Thing

Applied ICT A Level Unit 3 - Database Design

Note: this page applies to the AQA Applied ICT A level specification. This exam was withdrawn in 2012, with final exams in 2013. The content will be retained as an archive and because it has some stuff that might be quite useful for someone or other

Circuit board imagePart 6 - Testing

Now you have your database built, you need to show that you've tested it effectively.

The key to this is to go back to your client needs and evaluation criteria. You're testing the database to see whether it does what it should do. Keep going back to those client needs!

How to test:

Take the first evaluation criteria. You should have an idea of how you're going to test that criteria if you've drawn up the table from Part 4.

Decide exactly what inputs you're going to use to test the criteria and what the expected outcome should be. Try to use a range of data. You need to test:

Expected inputs - the sorts of things the database should deal with without any problems

Extreme inputs - things (usually numbers) that the database should just about be able to cope with. These are often called boundary values. For example, if you should be able to book an appointment today or in the future then you need to test that you can book it today.

Erroneous data - data which the database should not allow. This should throw up sensible error messages. When you test this data that's what you're looking for - for example, try testing a date in the past or a negative number.

You can lay out tests in lots of ways, but a table isn't a bad idea:

Test # Testing Test Input Expected outcome Actual outcome Comments
1 An accurate count of all customers in the database can be reported (Eval Crit 1) rptCustomerList will be run with 7 customers in tblCustomer Report should show a count of 7 Report showed a count of 7 This is the expected value. The criteria has been met. Screenshot 42, pg. 143.
9 VAT will be calculated accurately (Eval Crit 6) A job will be created with 4 hours of labour and additional costs of £22.63 VAT of £13.21 will be calculated VAT of £13.21 was calculated This is the expected value. The criteria has been met. Screenshot 49, pg. 152.
12 Hours required can be entered in the database to calculate labour costs (Eval Crit 9) A job will be created with 1 hour (boundary value) The job will be accepted The job was accepted This is the expected value. The criteria has been met. Screenshot 52, pg. 154.
13 Hours required can be entered in the database to calculate labour costs (Eval Crit 9) A job will be created with -3 hours (erroneous value) The job will not be accepted. An error message will be displayed. The error message will explain that values for job hours need to be positive The job was not accepted. A suitable error message was displayed This is the expected result. The criteria has been met. Screenshot 53, pg. 154.

This can get quite detailed - don't get too bogged down! If you test every criteria effectively then you'll get the marks here.

Markgrid AO4 row 3
Note: this markscheme is a copy of one available freely on the AQA Applied ICT webpages. It is copyright AQA and reproduced here simply to make access easier for students. No attempt to claim copyright is being made, although I could have copied the text into my own interpretation...

You should probably look at That Blue Square Blog for all the really good other A Level stuff.