Unit 2 Creating Systems to
Manage Information 2019
Level 3 National in
Information Technology
Additional Sample Assessment
Material
Part A
Example Solution
Contents
Introduction .............................................................................................. 3
Activity 1 Database Relationship Screenprint ................................................. 3
Activity 2 – Table Structures and Validation ................................................... 4
Table Structures...................................................................................... 4
Table Validation ...................................................................................... 4
Presence and Length Check ................................................................... 4
Value Lookup or Range Check ................................................................ 4
Table Lookup ....................................................................................... 4
Format Check ...................................................................................... 4
Activity 3 .................................................................................................. 5
Queries .................................................................................................. 5
Query a ............................................................................................... 5
Query b ............................................................................................... 6
Report ................................................................................................... 7
Example 1 ........................................................................................... 7
Example 2 ........................................................................................... 9
Activity 4 - Testing ................................................................................... 10
Activity 5 – Evaluation .............................................................................. 13
AddSAM
Introduction
This solution shown is one example only. It is important to read the guidance with
each activity. No assumption is made that a method that differs from the solution
shown is incorrect.
Activity 1 Database Relationship Screenprint
Activity 2 – Table Structure and Validation – AddSAM 3|Page
Activity 2 – Table Structures and Validation
Table Structures
Table Validation
Presence and Length Check Value Lookup or Range Check
Table Lookup Format Check
Activity 2 – Table Structure and Validation – AddSAM 4|Page
Activity 3
Queries
Query a
Create a query to display an alphabetically sorted list of the events running on the
20th and 21st of December. It must show event description and event ticket price
only.
Activity 3 – Queries and Report – AddSAM 5|Page
Query b
Create a query that will calculate:
• the number of table tickets sold
• the income the tickets sold would generate.
Display:
• the event description
• the number of table seat tickets sold
• the income generated.
Activity 3 – Queries and Report – AddSAM 6|Page
Report
Example 1
Calculation for
table seats
Calculation for no table
seats
Calculation for total tickets
Many different ways to achieve. Could use grouping on Event Description etc. Any
method that shows what we want is valid.
Activity 3 – Queries and Report – AddSAM 7|Page
Presentation of report cannot be marked from screenprint. Need to see
actual report. Report here for illustration purposes only.
Activity 3 – Queries and Report – AddSAM 8|Page
Example 2
Activity 3 – Queries and Report – AddSAM 9|Page
Activity 4 - Testing
Screenprints may be on the small side here. Learners can put the screenshots after the table or use A3.
Test type Add suitable test data Add the results you Add screenprint(s) of the results of this test carried out on your Only complete this
No test would expect to get database. column if the results are
from a fully working Ensure you show the test data used in the screenprint(s) not as expected
system
• Explain the error
If you correct the error
explain how you have
done it including a
screenprint
1 R CustomerID:4 An error message
Surname: blank telling the user the
HouseNumber:32 surname is required
Postcode: BB1 1BB
2 R CustomerID:4 No error message but
Surname:Driver the user will not be able
HouseNumber:32 to add a character
Postcode 11B B11 where a number should
be or a number where a
character should be.
The character will not
be input
Activity 4 – Structure Testing – AddSAM 10 | P a g e
3 X SeatSaleID:Autonumber Error message saying
EventID:4 they must select an
CustomerID:69 item from the list.
SeatType: Table
NumTickets:1
4 R SeatSaleID:Autonumber Error message saying
EventID:1 they must select an
CustomerID:1 item from the list.
SeatType:both
NumTickets:1
5 X SeatSaleID:Autonumber Error message telling
EventID:1 the user the input has
CustomerID:1 to be between 1 and 8
SeatType:Table
NumTickets:0
Activity 4 – Structure Testing – AddSAM 11 | P a g e
6 X SeatSaleID:Autonumber Error message telling
EventID:1 the user the input has
CustomerID:1 to be between 1 and 8
SeatType:Table
NumTickets:9
Activity 4 – Structure Testing – AddSAM 12 | P a g e
Activity 5 – Evaluation
No evaluation example included as these can end up becoming the ‘only way’
candidates evidence this activity.
Activity 5 – Structure Evaluation – AddSAM 13 | P a g e
