Learning Aims and Objectives:
Aim: In this week's page, students will learn the.
Objectives:
1. By the end of this week's page students will be able to.
2. By the end of the week's page students will be able to.
3. By the end of the week's page students will be able to .
4. By the end of the week's page students will be able to
5. By the end of the week's page students will be able to.
• Different types of testing: referential integrity, functionality, security.
• Selection and use of appropriate test data: erroneous data, extreme data.
• Recording appropriate test documentation.
When creating any product the key to its ultimate success is the appropriate testing that occurs throughout its development and at the point before release. This is done within database development also as it is essential to the integrity of the information that is created from the data contained within.
We use test plans to record the checks, tests, and features of the databases, this typically will be presented to users in a table format as displayed below.
|
Test No |
Type of test (N= Normal , R= Erroneous, X = Extreme) |
Test data |
Expected results |
Screenprint(s) of the results |
Results are not as expected, correction of the error and how, plus any addition screenprint(s) |
||
Normal Tests = Normal, day to day entry,
Erroneous Tests = Data that is known to be incorrect to test error handling.
Extreme Tests = Data that is beyond the limits of input, ie. a name that is longer than the 50 field length permitted.
• Using testing outcomes to improve and refine a database solution.
Links to Learning Outcomes |
Links to Assessment criteria |
|
|---|---|---|
|
AO1 Demonstrate knowledge of database development terminology, standards, concepts and processes AO2 Apply knowledge and understanding of database development terminology, standards, concepts and processes to create a software product to meet a client brief AO3 Analyse information about database problems and data from test results to optimise the performance of a database solution
|
Reading: Read and understand texts, selecting material appropriate to purpose, collating from different sources and making comparisons and cross-references as appropriate.
Listening: Listen and respond to speakers ideas and perspectives, and how they construct and express meanings
Using Numbers: Counting, Place value, adding and subtracting, multiplying and dividing.
Analysis of information: Interpreting Results, Drawing conclusions from data, Comparing data
Collect and record data: Questionnaires, Observation, Tally
Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.
Peer Assessment of Independent Work - Learners work in groups to assess each other's work and make recommendations for improvement.